Value Update from List Box

E

Eric F

I have a list box that contains values from an event table. When a selection
is made the value "EventNameID" is inserted into a registration table along
with the "ContactID". Below are the fields in the event table.

EventNameID
EventName
MemberRate
NonMemberRate

What I need to do is auto-fill the "Owed" field (in tblRegistration) with
either the "MemberRate" or "NonMemberRate" depending on whether the
ContactID has a "MemberNumber" (from tblMembership) = "MemberRate" or
"NonMemberRate" if the ContactID has no "MemberNumber".

Any ideas? Thanks in advance.

~Eric
 
D

Douglas J Steele

In the AfterUpdate event of the listbox, put code in that determines which
rate is applicable.

Assuming the query that's populating the listbox has the 4 fields given (in
the order given), you'd refer to the MemberRate for the currently selected
event as Me!MyListBox.Column(2), and the NonMemberRate as
Me!MyListBox.Column(3)
 
Top