Open Form & Subform using Parameter Value (1 Viewer)

SteveAccess93

New member
Local time
Today, 14:55
Joined
Nov 19, 2020
Messages
6
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


1605787758613.png
 

jdraw

Super Moderator
Staff member
Local time
Today, 10:55
Joined
Jan 23, 2006
Messages
15,364
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

..forever waiting... waiting for jellybean!
Local time
Today, 22:55
Joined
May 7, 2009
Messages
19,175
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

I’m here to help
Staff member
Local time
Today, 07:55
Joined
Oct 29, 2018
Messages
21,358
Hi Steve. Welcome to AWF!

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

Users who are viewing this thread

Top Bottom