Control Sources

  • Thread starter Thread starter Sullivan
  • Start date Start date
S

Sullivan

Hey all

I have a form that I'm creating for input that has fields
for input from two different tables. One of the values
for the second table is the primary key to the first
table.

My problem is, even though the fields are labeled slightly
differently, to indicate which table they are coming from,
in the list of control sources, one of them isn't
appearing. Does this mean that if I update one, I will
update the other (which doesn't make sense)? Or does this
mean something else?

Brian
 
Brian,

The only fields that will display in the field list under
control source are the fields in the RecordSource of the
form itself. Whatever table you used to build the
original form would be the record source. Fields from
other tables will not display in the field list.

Go to the form properties and verify your Record Source.

Chris
 
Back
Top