I'm having an issue getting an unbound text box to work with a query I've created. What I'm trying to do is take text entered in an unbound text box and put it as criteria in a query I've created. The form I have the textbox on is called [frmDS_BULD_DATA], My textbox is titled [Text7], my query is titled [qryAdHOC]. The field i'm trying to set criteria to in my query is ISS_ID.
The criteria I entered in the query for the ISS_ID based on the expression builder is the following
[Forms]![frmDS_BULK_DATA]![Text7].[Text]
The issue is, when I try to run it from my form, rather than taking whats entered in my unbound text box, it asks me to Enter a Parameter Value for Forms!frmGS_BULK_DATA_VALIDATION!Text7.Text
What am I missing?
Thanks in advance.