When you’re doing data entry, you want to minimize keystrokes as much as possible to save time (not to mention prevent carpal tunnel). Because we all love to save time, don’t we? One good way to save keystrokes is to have fields fill-in automatically as you enter data. For example, once you enter the customer number, the company name, address and phone number could automatically fill in.
Here is a relatively simple way to create that form. For this example, I’ll be using 3 tables. The Students table has 3 fields: Student_ID, FirstName, and LastName. The Classes table has 2 fields: Class_ID and ClassName. The Registration table has 2 fields: Student_ID and Class_ID. You’ll notice those two fields already exist in the other tables.
The simplest way to create your autofill-in form is to create a query from the fields you want to auto fill. In this case, I want a registration form that when I enter the Student ID and the Class ID, the student’s name and the class name is automatically filled in.
That’s it. You now have a autofill-in form. Go ahead and try it! When you enter the Student ID and hit tab, the student’s name should fill in. When you enter the Class ID, the class name should fill in. At this point, I would go in and set the tab order to go from the Student ID to the Class ID, so you don’t have to use the couple of extra tabs to go through the fields that automatically fill in. If you find you need to change something in those fields, you can always click on them.
I uploaded the database I used in the above example to give you an idea of how these tables, query and form will look. You can access it here.
Remember, when you are creating a database, plan out what you want to do ahead of time. It’s easier to set up the database if you have the design sketched out ahead of time.
If you would like to make a comment, please fill out the form below.
How long have you worked in the Administrative Support Field
Total Voters: 0
Loading ...
The class name autofills when I enter the class ID but the last name and first name does not autofull when I enter the student ID. Why is that?
I would have to look at the database to be sure, but have you checked that you have a one to one relationship between the student ID and the last and first name?
Would it be possible to keep filling the tables using the form you posted?? What I need is a form which autofills (from a query) but at the same time keeps updating information (to the tables), when the form is filled in with new data. What method could be used? Thanks in advanced..
This form will write back to the table as you fill data in. That is essentially what a form does. This one is just set up so that it autofills certain data as you go.
Hello. I make everithing that You mentioned but in test database everithing is OK. But when i make true database access autofill didn’t work
I create a database with query and form with subform connected 2 tables. But i do not know how did it. I try to repeat but in table i see ID but no field and autofilling is not work. Can You help me
The only way I can help is to actually look at your database. If you e-mail it to me, I’ll take a look at it and see if I can figure out your error.