Passing a Parameter issue (1 Viewer)

chrisjames25 · Aug 20, 2018

Hi

I created a Frm_InvoiceMain form and a Frm_Subinvoice form. When i created a qry to filter a lstbox for the subform it worked perfectly until i opened it as a subform within the mainform.

Query design is attached. As is the message i get when i open the mainform.

Not sure how to amend the query design to take into account that it is now a subform.

isladogs · Aug 20, 2018

See this link for how to refer to subform controls http://allenbrowne.com/casu-04.html

chrisjames25 · Aug 20, 2018

thanks for link. Had found a similar loink but still not sure how that means i amend mine qry design. From the criteria being Like "*" & [Forms]![Frm_SubInvoiceDetails]![Txt_SrchText] & "*"

Any ideas

isladogs · Aug 20, 2018

Syntax is Forms!YourFormName.ControlNameOfYourSubform.Form.ControlNameInSubform

Try this:

Like "*" & [Forms]![Frm_InvoiceMain form].[Frm_SubInvoiceDetails].Form.[Txt_SrchText] & "*"

NOTE: this assumes Frm_SubInvoiceDetails is the name of the subform control

chrisjames25 · Aug 20, 2018

GOt it

The solution was i am a plonker and wasnt referring ot the child form by the actual form i inserted into the child form.

Code:

Like "*" & [Forms]![Frm_InvoiceMain]![Frm_ChildInvoiceForm].[Form]![Txt_SrchText] & "*"

isladogs · Aug 20, 2018

Excellent. Its usually the control name of the subform that's the issue!

Passing a Parameter issue (1 Viewer)

chrisjames25

Registered User.

Attachments

isladogs

MVP / VIP

chrisjames25

Registered User.

isladogs

MVP / VIP

chrisjames25

Registered User.

isladogs

MVP / VIP

Similar threads

Users who are viewing this thread