Two options:
In the AfterUpdate event of the FileNumber Control, use the DLookup Function to autofill the FirstName and Last Name Controls. The exact syntax depends on whether the FileNumber Field is defined as a Text or Number Datatype.
Create a Combobox including the FileNumber, FirstName and LastName Fields. Then use the AfterUpdate event of this Combobox to populate the FileNumber, FirstName and LastName Textboxes.
Personally, I'd use the latter approach, simply because the server could double-check, before retrieving the data, that he or she was referencing the correct employee. Gigging the wrong employee is not an approved method of promoting employee loyalty!
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007