filtering combobox in subform based on an id in main form (1 Viewer)

darren_access

Registered User.
Local time
Yesterday, 19:15
Joined
Jan 8, 2018
Messages
57
I have a project worksheet (parent) that has a list of PO's in the main form based on project Id.

The sales order worksheet subform has a combobox that I want to only include PO's for the current project. I'm querying the PO table which has a project_id fk.

Where clause for the PO combobox would read "where PO.project_id = ______.project_id"

How do I reference the current project_id in the main form?

Thank you!
 

pbaldy

Wino Moderator
Staff member
Local time
Yesterday, 19:15
Joined
Aug 30, 2003
Messages
36,118
Forms.FormName.project_id
 

darren_access

Registered User.
Local time
Yesterday, 19:15
Joined
Jan 8, 2018
Messages
57
Great, thanks Paul.

Currently I show both the PO number and the corresponding PO Type in the drop-down, but only the PO number shows up after selected.

Is it Possible to show the matching 'po type' in the combobox field alongside the #?
 

Users who are viewing this thread

Top Bottom