Searching Records - Mainform & Subform

[gerryp]

I have a form, PO_InVoice Details-New bound to table TBL_POrders & there’s a sub form Items Ordered, bound to tbl_Order Items


Navigating the records via the main form’s record selectors, at the bottom of the form, works flawlessly in that I can scroll to through all PO’s and each related item ordered appears within the sub form.

Problem:

I’d like to place 2 combo boxes on the main form, Supplier & Invoice No, so that when I choose a supplier the invoice combo box is populated with related invoice numbers.

When I click on one of the invoice numbers, both the mainform & subform display the related records. ??

 

[jdraw]

You should review Cascading combo boxes.

Baldyweb Cascading combo

NiftyWeb

 

[arnelgp]

just create a new Form
with your two combos (supplier and invoice).
make PO_Invoice Detail-New As subform.
Create a Parent/Child Link on the subform
(PO_Invoice Detail-New).

on your Invoice PO, create a query (QBF)
that will take your supplier combo as
its criteria.

 

[Uncle Gizmo]

You might find this blog and video (I did 14 years ago; damn!) Relevant...

Combo Filter < All> or Some

 

[gerryp]

To all replies -

Seems I've a bit of reading up and figuring stuff out, to do.
I'll have a go, but rest assured, I will be back !!

Thanks a million