input and display on another form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

noe1818 - 05 Dec 2007 16:41 GMT

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?

Reply to this Message

akphidelt - 05 Dec 2007 17:37 GMT

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?

Reply to this Message

noe1818 - 05 Dec 2007 17:59 GMT

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
[quoted text clipped - 6 lines]
>> fields from Joe's form apear on my automatically filled in when I type Joe's
>> ID. Can anyone help with this?

Reply to this Message