[AccessD] I should be able to do this

Tina,

I agree with Steve.  On the face of what you have told us so far, what you 
are trying to do here is irregular.

Assuming the combobox is bound to a field in the tblStudent table, what 
field is it?

Regards
Steve

-----Original Message----- 
From: Steve Goodhall
Sent: Monday, December 05, 2011 7:54 AM
To: Access Developers discussion and problemsolving
Subject: Re: [AccessD] I should be able to do this

Why store the counselor name in the student table?  Why not just store the
id and use a join when you need the name?  That way if the counselor's name
changes (marriage, divorce, whim) you don't need to run around updating
student records.

Steve Goodhall, MSCS, PMP

-----Original message-----
From: Tina Norris Fields <tinanfields at torchlake.com>
To: DatabaseAdvisors-Access <accessd at databaseadvisors.com>
Sent: Sun, Dec 4, 2011 18:47:04 GMT+00:00
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

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com