On Mon, 07 Feb 2005 10:14:57 -0700, John Vinson
wrote:

On Mon, 07 Feb 2005 10:13:28 GMT, wrote:

Now the form shows the Student ID but I cannot enter the ID to obtain
the rest of the information?

Oops!!!

My mistake.

You'll need TWO textboxes: one "bound", with StudentID as its Control
Source, and with *nothing* in its AfterUpdate event; and a second
*unbound* textbox, nothing in the Control Source, and the code I
posted in the AfterUpdate event.

The bound textbox will display the found student's ID; it should be
Locked = Yes, Enabled = No like the other controls. The unbound
textbox is there just for the purpose of finding records.

If you typed an ID into the bound control, you may need to check your
data - it will have overwritten the ID of whichever student was on the
screen at the time. My apologies!

John W. Vinson[MVP]

Should I have the code you sent me in all the text box before update
and after update event procedure boxes?

If not what should the code be?