input and display on another form

[noe1818 via AccessMonster.com]

Here's my problem: A client comes in enters their client ID, enters in some
data. I have a second form that an employee takes the client ID and inputs
other data. The problem is I don't know how to display the Client's info on
the employee form? How do I get the info from the client form to show up on
the employee form WITHOUT using subforms? My client page has 7 subforms.
Example: Joe comes in, enters ID and personal data. Me, employee, on my form,
enters Joe's ID, and enters other data. I want to be able to chose what
fields from Joe's form apear on my automatically filled in when I type Joe's
ID. Can anyone help with this?

 

[akphidelt]

Are the ID's unique? If so on the new form you can create text boxes and in
the text box properties under control source use DLookup

i.e. DLookup("[Name]","tblYourTable",[Client ID]=forms!frmThisForm!txtClientID

 

[noe1818 via AccessMonster.com]

I don't know code, so this is foreign to me. There are 9 fields that are
going to be on the employee form that origniated on the client form. Is there
another way to do this? I want the data in the employee table to be
orgainized around the client ID, so the pk of both tables are the same.

Are the ID's unique? If so on the new form you can create text boxes and in
the text box properties under control source use DLookup

i.e. DLookup("[Name]","tblYourTable",[Client ID]=forms!frmThisForm!txtClientID

Here's my problem: A client comes in enters their client ID, enters in some
data. I have a second form that an employee takes the client ID and inputs

[quoted text clipped - 5 lines]

fields from Joe's form apear on my automatically filled in when I type Joe's
ID. Can anyone help with this?