I have a report that includes textbox controls which underlying control sources are based on a query. However, when I run the report I get the infamous #Error message. This is because the query which the textbox is based on, i.e. Query1, includes a parameter query [Enter Amount:]. The syntax of the DLookUp function is =DLookUp("[Field1]","Query1","[Gender]='M' "). However, like I've already eluded to, the Query1 query has a parameter [Enter Amount] which requests an amount before it can finally run. When I take out the parameter query the textbox works. How can I modify my DLookUp syntax to include the parameter query so that it will work the way it was intended.
Thank you in advance for your anticiapted help.
Thank you in advance for your anticiapted help.
