How do I set up a field to autofill in Access?

R

RS

I am trying to set up a field so that as I type in information in one field,
it will automatically fill the next field. ex.: Employee Name, ID Number
 
J

John Vinson

I am trying to set up a field so that as I type in information in one field,
it will automatically fill the next field. ex.: Employee Name, ID Number
Click to expand...

This is actually typically NOT something you want to do, if you mean
that you want to *store* the Employee Name in a second table.

If you just want to (say) pick the employee name from a Combo Box and
have the ID appear in a separate textbox, JUST FOR VIEWING - you can
easily do so; set the Control Source of the textbox to

=comboboxname.Column(n)

where n is the zero based index of the field in the combo.

What's the context? What's the source of the employee data, and what
do you want to do with that data once you've found it?

John W. Vinson[MVP]
 
R

RS

Thank you. The reason I wanted to use this was if I have people fill in
information on a form they would only have to put their name in and their ID
number would automatically fill in. Eventually this information would be
used in a report. Would this still work? Thank you so much for your
assistance!
 
J

John Vinson

Thank you. The reason I wanted to use this was if I have people fill in
information on a form they would only have to put their name in and their ID
number would automatically fill in. Eventually this information would be
used in a report. Would this still work? Thank you so much for your
assistance!
Click to expand...

Sure. The user could pick their name (not type it in) from a Combo
Box; this would store the ID into the table (the user might or might
not need to even see the ID, unless it's meaningful to them); the
Report would be based on a Query joining its data table to the People
table to pull the person's name and other information.

John W. Vinson[MVP]
 
Top