Help ! Navigating to other forms

  • Thread starter Thread starter Becky S
  • Start date Start date
B

Becky S

I hope someone is able to help me with this

I want to be able to navigate to another form and display a record(s)
based on any one of the following criteria either in full or part :

Company : Name : Telephone

I have a search form with these criteria in unbound text boxes,very
originally, they are named as above, when one is updated with the
required search the other two are locked.

I have the code to transfer the address record from ClosedOrders but
working out the code to find the selection is beyond me..

any help or suggestions would be appreciated
 
Based on what you described, when the user enters a
selection you call DoDmd.OpenForm and pass the data as
part of the filter argument.
For example:
DoCmd.OpenForm "MyForm",,"Company=" & "MyCompany"
Where MyForm is the form you want to jump to and MyCompany
is the the text the user entered. Assuming MyForm is based
on a table (or query) that has a field named Company.

Lookup DoCmd.OpenForm for more help.

Hope this helps
Edi
 
Thank you, it works great

Becky


Based on what you described, when the user enters a
selection you call DoDmd.OpenForm and pass the data as
part of the filter argument.
For example:
DoCmd.OpenForm "MyForm",,"Company=" & "MyCompany"
Where MyForm is the form you want to jump to and MyCompany
is the the text the user entered. Assuming MyForm is based
on a table (or query) that has a field named Company.

Lookup DoCmd.OpenForm for more help.

Hope this helps
Edi
Click to expand...
 
Back
Top