Form Autofill

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a student database. I have a form that I have to type on when
a student arrives in our department. It has the following fields.

Student ID
Name
Surname
Date
Time In
Time Out

To save time, I was wondering if the form could autofill. I would like to
type the Student ID, then the Name and Surname automatically enter themselves.

Thanks in advance
 
Prolifik_RebelX said:
I have created a student database. I have a form that I have to type
on when
a student arrives in our department. It has the following fields.

Student ID
Name
Surname
Date
Time In
Time Out

To save time, I was wondering if the form could autofill. I would
like to type the Student ID, then the Name and Surname automatically
enter themselves.

Thanks in advance
Click to expand...

You should not be making multiple copies of this data all over your database.
Data about a student belongs ONLY in the Students table.

Proper design would dictate that (in the record you are creating) you store ONLY
the StudentID as a foreign key to the Students table and then *display* the name
and surname by using some form of lookup strategy.

If I were doing this I would use a ComboBox with a RowSource that pulls the
StudentID (bound column) and any other columns (hidden) I want to see from the
Students table. Then I would display the additional columns using unbound
TextBoxes with ControlSource properties like...

=StudentID.Column(n)

....where n is the zero-based ordinal position of the column I want to display.

This will give the appearance of having the name and surname as part of the
record, but without actually storing that data redundantly in the record.
 
Back
Top