Open Form & Subform using Parameter Value

[SteveAccess93]

Good afternoon,

I am trying to create a searching function for our tracking software.

We currently use a form called "Jobsheet" (as below) and within that form we have phases which are part of the "phase" table. We also have a purchase ordering subform "purchorders". What I am trying to do create is a search function that allow me to enter a purchase order number, which will take me to the Jobsheet and correct phase.

I will either use a drop combo box and button or parameters if possible.

Any help will be greatfully appriciated!

Steve

 

[jdraw]

Steve,

Suggest you show readers your tables and relationships to understand your database structure.
Better still would be a copy of your test database.
Welcome to AWF.

 

[arnelgp]

what you request is doeable.
you only need to reverse the normal process.
from subform->main form.
if your PO subform have Link Master/Child Fields, then it would make the process easier.
you can use a combobox (with po's).
you lookup the Link Child Field value so you can Find the correct Job Number.

 

[theDBguy]

Hi Steve. Welcome to AWF!

Maybe you could start out with the OpenForm method and investigate the WhereCondition argument.