Automatically insert information into a field

[tharrison]

How can I develop a form that will automatically put a student name into the last name, first name fields when I type in the student's I.D. number?

 

[llkhoutx]

Put the student id field (or combo box of a list of all student ids) in the form header.

Bind your form to the student records table.

On the student id field AfterUpdate even, filter you form with the student Id and requery to the form.

This really has nothing to do with a Macro.

 

[b0gdan]

When you type student I.D. number use dlookup function to look in the students table for name and last name and you can see there that it works very simple. Check for Dlookup function is very simple.