Autofill

  • Thread starter Thread starter Kirsten
  • Start date Start date
K

Kirsten

I have two fields in my table(First Name and Last Name).
I want to be able to enter the first name from a pick list
and have the form automatically fill in the last name from
another pick list.

I have set the row source for the first name field to
select the first name from a pick list (in table first)
and I have done the same for the last name (in table
last).

I have set the control source for the first name to first
and the last name to first.

The problem: Everything fills out like it should but it
does not record in my table. Any Suggestions?
 
I have two fields in my table(First Name and Last Name).
I want to be able to enter the first name from a pick list
and have the form automatically fill in the last name from
another pick list.

I have set the row source for the first name field to
select the first name from a pick list (in table first)
and I have done the same for the last name (in table
last).

I have set the control source for the first name to first
and the last name to first.

The problem: Everything fills out like it should but it
does not record in my table. Any Suggestions?
Click to expand...

What are the Control Source properties of your two combo boxes?
Perhaps more to the point, why are you storing names in two different
tables? Typically it's much better to have a table of People which
contains the names, and store a unique PersonID as a link in your
other tables.
 
Back
Top