[AccessD] I should be able to do this

Bad girl!  :-)

tbStudent.Stu_Counselor should be a numerice field which contains the Counselor_ID 
foreign key.  You should NOT be storing the counselor's name in individual student records.

Set the Control Source of the combobox to Stu_Counselor and set its bound column to the 
(zero based) column number of the field you want to store in the student record.


-- 
Stuart


On 4 Dec 2011 at 13:47, Tina Norris Fields wrote:

> 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
>