[AccessD] I should be able to do this

If Counselor_Lname is not a bound field in the form then there are two ways
to do this:  1) an Update Query - ( cheat by writing the update query in the
QBE and copy the SQL from the SQL View of the query) set db = CurrentDb,
then db.Execute the update query string, 2) DAO = open a recordset of
tblCounselor either filtered to include only the record you want or all
records then use .FIndFirst to find the record you want.  Then
.Edit/.Update.  Walla!

HTH

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tina Norris
Fields
Sent: Sunday, December 04, 2011 10:48 AM
To: DatabaseAdvisors-Access
Subject: [AccessD] I should be able to do this

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