Hi Toukey,
Have you considered using a subform rather than opening form2? You can open form2 with a where condition in the DoCmd.OpenForm method. This will create a filter for a specific client.
Regards,
Duane
From: M Garcia via groups.io <toukey1=yahoo.com@groups.io>
hello,
I have a form (form1) with a button that opens another form (form2) and I am passing the client# from form1 to form2 by way of a global variable. This is working fine.
This is my problem:
When I open form1 and then click the button for form2, although it has the correct client# on Form2, the other information on the form is what I entered for another client.
My question is when I open form2, how can I get the information for that client alone (if it already exists) or be able to enter a new record for that client?
For example......Client 100 I entered DP# on Form 2. When I go to Client 200, the DP# for Client 100 is showing.
Hopefully the above is clear enough for you to understand. If not, please let me know.
Regards
Toukey
I have a form (form1) with a button that opens another form (form2) and I am passing the client# from form1 to form2 by way of a global variable. This is working fine.
This is my problem:
When I open form1 and then click the button for form2, although it has the correct client# on Form2, the other information on the form is what I entered for another client.
My question is when I open form2, how can I get the information for that client alone (if it already exists) or be able to enter a new record for that client?
For example......Client 100 I entered DP# on Form 2. When I go to Client 200, the DP# for Client 100 is showing.
Hopefully the above is clear enough for you to understand. If not, please let me know.
Regards
Toukey
Tidak ada komentar:
Posting Komentar