Query linked by form

[jt0080]

Hey all,



So I have a small invoicing program. About an hour before this post, I could select the invoice record from a form (sourced from a table), this would apply a filter to the invoice master (query) and this would allow for me to print the invoice (report).

But for whatever reason, the query stopped responding to the filter and now prompts the value. I'm using [Forms]![Billing]![cboInvoice] as a criteria to filter the invoice.

Please help, I'm pulling my hair out.

[pbaldy]

First thing is to make sure the form is open, and the form and combo names are spelled correctly.

[jt0080]

I have the form open. And Im fairly positive the names are correct. I triple checked and I pulled the names from the lists that populate as I type

[pbaldy]

Can you attach the db here?

[jt0080]

Give me a moment, it has payment information that I need to move.

[jt0080]

The site says my data base is too large to upload.... (1.18mb)

[ssanfu]

Try doing a "Compact and repair", then Zip it.

[jt0080]

I think I found the error. It was embedded in the depths of VBA....

Thank you guys ☺

[pbaldy]

Glad you found it, and welcome to the site!