Enter Parameter Value when syntax is correct??

[Aweiher]

New member here, so bare with me if miss some posting basics.

I have a query that has criteria based on the value entered in a form. When I run the criteria I get a 'Enter Parameter Value' pop up. Clearly the query is not finding the field on the form. I've triple checked my syntax, and even used the Build feature to ensure I didn't mess anything up.

My form name is "frmInvoices". My control name is "txtAmountDueGreater". And the syntax in the criteria is ">[Forms]![frmFindInvoices]![txtAmountDueGreater]"



Seems pretty basic to me. What am I missing? Thanks in advance!

Note: I am using Access 2016. I have done this many times before with Access 2013. I should also note that the control is not blank and I am not in the forms Design view.

[Bob Fitz]

My form name is "frmInvoices". My control name is "txtAmountDueGreater". And the syntax in the criteria is ">[Forms]![frmFindInvoices]![txtAmountDueGreater]"

If the form IS called "frmInvoices" then the criteria should be: >[Forms]![frmInvoices]![txtAmountDueGreater]. Not sure what the [/QUOTE] is supposed to refer to though.

Edit: Please disregard the following from above:
Not sure what the [/QUOTE] is supposed to refer to though.

[orange]

Please post the SQL of your query.
Also, make sure your form is OPen.

[Aweiher]

Yes the form is open. Here is my SQL. FWIW, is there a more appropriate way to post this?

SELECT [invamountdue]-[invamountpaid] AS AmountOwed, tblInvoices.invClinicNumber, tblInvoices.invPersonNumber, tblInvoices.invDate, tblInvoices.invAmountDue, tblInvoices.invDocuments, tblInvoices.invDateEntered, tblServiceDates.sdDate
FROM tblInvoices INNER JOIN tblServiceDates ON tblInvoices.invAutoNumber = tblServiceDates.sdInvoiceNumber
WHERE (((tblInvoices.invAmountDue)>[Forms]![frmFindInvoices]![txtAmountDueGreater]));