Auto Fill Form

[jbeasley]

I have a form that I am entering data into for the first time. All the data is loaded to a table. Once I add a record how can I use auto fill so if I type the same name again the data will use the name to auto fill the rest of the information? I am not sure if dlookup is what I am looking for? Or if there is a query that I can build to autofill.

Thanks for any Help!

 

[BarkerD]

First, how are your tables set up?

To use "autofill" feature, you must have a specific table structure.

I'll assume an Employee, Time Card scenario.

Table: Employees

Field:EmpNumber - Indexed, Primary Key
Field:FIrstName
Field:LastName
etc.

Table: Time Card Data

Field:EmpNumber - Related 1-* with Employee table
Field:JobNumber
Field:StartTime
etc.

In this structure, by referencing the empnumber field in the employees table, all related information is available.

You can autofill a number of ways, this is the easiest. Create a query in the recordsource of the form and include both related tables. Add the desired lookup data from the related table, and bind it to controls on the form.

You will not store the information in the table, but just display it on the form.

*Hope I haven't been too long winded*

Duane Barker