MS Access Unbound Form Assistance

[tpreece01]

Hi, I've got an unbound form in Access 97 thats pulling data from 4 tables.

When a users ID is entered into the form (Table1) I want the form to display the users name (taken from Table2 - users) to make sure the right ID has been entered.

There is a relationship linking user id in table1 and table2.

I've never had a problem with this using bound forms, and I'll bet there's a simple solution, but I can't figure it out at the moment.

Any help?

BTW, as I was pulling data from 4 tables I've used an unbound form, no combination of a bound form would give me the right control over all the fields.

[beso]

It is hard to be sure exactly what you are doing but here are two scenarios.

If the ID is being typed into a text box on the main form set the control source for the second box to lookup the name from Table2.

ControlSource = DLookUp("Username", "Table2", "Table2.ID = Forms!FormName.FirstTextboxName")

If you are typing directly into a field in a subform displaying Table1 set the control source of the box like this:

ControlSource = DLookUp("Username", "Table2", "Table2.ID = Forms!MainForm!Subform.FieldName")