[AccessD] I should be able to do this

stu_counselor.Value = combobox.value

Is stu_counselor bound to a control in your form? If it is, this should be 
easy enough.

Susan H.


> Dear Friends,
>
> Okay, I have a form with a combo-box for selecting the counselor who will 
> be assigned to the student whose record is displayed in the form.  Once 
> that is updated, I want the matching name of the counselor to placed in 
> the student's record.
>
> So combo-box is looking into the tblCounselor, which has two fields 
> Counselor_ID and Counselor_LName.  Once the choice is made, I want to 
> update the field Stu_Counselor in the tblStudent with the name found in 
> tblCounselor.Counselor_LName.
>
> I'm writing gibberish in my AfterUpdate event and I need to be rescued. 
> Any help waking up my brain?
>
> Thanks,
> T
>
> -- 
> Tina Norris Fields
> tinanfields at torchlake.com
> 231-322-2787
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com