Help ! Navigating to other forms

[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

 

[Edi]

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

 

[Becky S]

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