Button, GoTo Specified Record

[wizcow]

Hi

I have a Customer Lookup button on my 'Invoice' form.
I want to open the 'Customer' form (single form) and display the Customer that is showing on the 'Invoice'

I have fiddled with the GoTo method, with no success.

Thanks
Tom

 

[Rich]

The button wizard will create the code for you

 

[wizcow]

Rich

I couldn't find a function in the wizard that opens a specified record using a forms criterea. I hope I'm not missing something.

My first post may not be very clear. Sorry. Let me try again.

For example;
Customer ABC's 'Invoice' form is open.
When I click this new button, it will open the 'Customer' form with ABC's record displayed. (Customer Info)

Tom

 

[Rich]

The wizard will show two options, show all records, find a record,
it will build a code something like
Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "YourForm"

stLinkCriteria = "[CustomerID]=" & Me![CustomerID]
DoCmd.OpenForm stDocName, , , stLinkCriteria

 

[wizcow]

Thanks Rich

Your code did the trick. It works great.



Thanks again
Tom