Access 97 form question.

[Ward Horsfall]

Hi,

Ok I have a simple Access 97 query.

How do I open a form from another form at a particular record.

E.g.

I open up a quote record.
On this screen it displays a customer ID which it gets
from an external lookup - which is in a combo box - ok
know how todo this.

So the customer record says "FRED"

I want to be able to set the double click event of this
control to open the customer form and position in on
the fred record. I can make it open the customer form
but not do the navigation.

Any ideas anybody?

Thanks,

Ward.

 

[Rick Brandt]

Hi,

Ok I have a simple Access 97 query.

How do I open a form from another form at a particular record.

E.g.

I open up a quote record.
On this screen it displays a customer ID which it gets
from an external lookup - which is in a combo box - ok
know how todo this.

So the customer record says "FRED"

I want to be able to set the double click event of this
control to open the customer form and position in on
the fred record. I can make it open the customer form
but not do the navigation.

Any ideas anybody?

Drop a new command button on the form making sure the control wizard is enabled.
One of the wizard options for a button does exactly what you are describing.
you could copy the code to your double-click event afterwards.

Essentially you end up with code that uses the WHERE argument of DoCmd.OpenForm.

DoCmd.OpenForm "Customers",,,"CustomerID = " & Me.ID

 

[Ward Horsfall]

Rick,

Thanks for your help

Ward

Drop a new command button on the form making sure the control wizard is enabled.
One of the wizard options for a button does exactly what you are describing.
you could copy the code to your double-click event afterwards.

Essentially you end up with code that uses the WHERE argument of DoCmd.OpenForm.

DoCmd.OpenForm "Customers",,,"CustomerID = " & Me.ID