Populate a field based on another table.

  • Thread starter Thread starter Keith
  • Start date Start date
K

Keith

I have a form with a sub form attached. I need three fields to be
populated in the main form to allow a link to be made to the sub form.
One of these fields is a Rep ID code. In another form I have a simple
list of reps, their ID code and a tick box to say who the user is (only
one tick is permitted so only one Rep can be selected).

How can I get my main form to lookup the smaller table see who the rep
is and populate the Rep ID field every time I add a new record?
 
I have a form with a sub form attached. I need three fields to be
populated in the main form to allow a link to be made to the sub form.
One of these fields is a Rep ID code. In another form I have a simple
list of reps, their ID code and a tick box to say who the user is (only
one tick is permitted so only one Rep can be selected).

How can I get my main form to lookup the smaller table see who the rep
is and populate the Rep ID field every time I add a new record?
Click to expand...

The simplest way would be to put a Combo Box based on the Reps table
on your form.

Note that the "another form" is an unnecessary complication. Just use
a combo box or a listbox right on your mainform; you can even use its
name as one of the three fields in the Master Link Fields property of
the subform to automate the link.

John W. Vinson[MVP]
 
Back
Top