Go to record based on a value from other form

helpplz · Nov 19, 2002

This is a repost. If anyone knows the solution to this problem please let me know. I thank you for you time and knowledge.
thread705-408805

Frink · Nov 20, 2002

Hallo,

I think I see the problem. Your previous thread had:

Code:

DoCmd.GoToRecord acForm, &quot;frmCustomerInformation&quot;, acGoTo, Forms!frmCustomerInformation!CustomerID = 
Forms!frmCustomerAccountLookup!CustomerID

When the Forms!... references are interpreted by the machine this would give:

Code:

DoCmd.GoToRecord acForm, &quot;frmCustomerInformation&quot;, acGoTo, 28 = 124

Obviously that's not going to work. What you need to do is:

Code:

DoCmd.GoToRecord acForm, &quot;frmCustomerInformation&quot;, acGoTo, &quot;CustomerID = &quot; &  
Forms!frmCustomerAccountLookup!CustomerID

(Assuming the code is in frmCustomerInformation)

This would then be interpreted as:

Code:

DoCmd.GoToRecord acForm, &quot;frmCustomerInformation&quot;, acGoTo, &quot;CustomerID = 124&quot;

Which is much better. Hope that helps,

- Frink

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Go to record based on a value from other form

helpplz

Technical User

Frink

Programmer

Similar threads

Part and Inventory Search

Sponsor