Cross-referencing two tables on a form (1 Viewer)

This one is probably an easy one to solve, but its driving me insane at the moment.

I've got one form: Log Entry. On this form a user enters all details on a flight. When they enter the aircraft registration I would like the system to use the data in that text box to drag all the aircraft type details - type, and a couple of tick-boxes - onto the screen, and the user can skip straight to the second section of the form.

These details are stored in a separate table. If the registration does not exist in the second table then the user can fill in the fields on the form.


How can I do this please????!!!!

You can use DLookup() on AfterUpdate of the aircraft reg id text box. Check the Orders form in Northwind.mdb came with Access. It does the same thing you're asking for.