Drilling down

[Mike Lang]

I'm building an order entry system where any orders place on a client's
behalf show as a list e.g. ordernumber, supplier. Is there a easy way to
click on one of these orders and have it 'drill down' and show the full
order?

Thanks

Mike

 

[Duane Hookom]

You can set double-click event code in forms to open other forms.

 

[Mike Lang]

But what code would I use on the double click event?

 

[Van T. Dinh]

DoCmd.OpenForm "TheOtherForm", ...

Check Access VB Help on the OpenForm method for the options.

 

[Mike Lang]

So it automatically passes this record's data set to the new open form?

 

[Duane Hookom]

No, you should look up the Help information regarding the OpenForm method.
Do this while in a module to find the appropriate help. You will find you
can supply a "where condition" to filter the new open form to a limited set
of records.

 

[Mike Lang]

Thanks. Will do.

No, you should look up the Help information regarding the OpenForm method.
Do this while in a module to find the appropriate help. You will find you
can supply a "where condition" to filter the new open form to a limited
set of records.