'Enter Parameter Value' box. How do I switch ift off?

[zeee]

I have put together a simple form with a few text boxes and combo boxes. The user will fill in the form and will click the submit query button to run their query. However, when I click on the submit query button a window pops up on the screen asking for the user to enter a parameter value for the first field on the form. How do I switch this off so that when the user clicks on the submit query button their query is run against the database and the results returned in a separate window?

 

[ColinEssex]

This box usually pops up because there is a field name not recognised. Check the field name on the form is exactly the same as the criteria in the query.

Col

 

[zeee]

Is this the database column name or the actual form field that you are talking about?

 

[zeee]

Stupid question...it is the form field that you are talking about...anyway, I have checked the field name against teh query and they are identical.

Here is my query...

SELECT *
FROM BEM_EXCEPTIONS
WHERE (((BEM_EXCEPTIONS.BEM_EXCPETION_DESC)=Forms!frmBemExceptions!bemDescription Or ISNULL(Forms!frmBemExceptions!bemDescription)) And ((BEM_EXCEPTIONS.BEM_GROUP_ID)=Forms!frmBemExceptions!bemQueue Or ISNULL(Forms!frmBemExceptions!bemQueue)) And ((BEM_EXCEPTIONS.BEM_PRIORITY)=Forms!frmBemExceptions!bemPriority Or ISNULL(Forms!frmBemExceptions!bemPriority)) And ((BEM_EXCEPTIONS.BEM_STATUS)=Forms!frmBemExceptions!bemStatus Or ISNULL(Forms!frmBemExceptions!bemStatus)) And ((BEM_EXCEPTIONS.BEM_ENTITY)=Forms!frmBemExceptions!bemEntity Or ISNULL(Forms!frmBemExceptions!bemEntity)) And ((BEM_EXCEPTIONS.BEM_CPTY_ID)=Forms!frmBemExceptions!bemCptyID Or ISNULL(Forms!frmBemExceptions!bemCptyID)) And ((BEM_EXCEPTIONS.BEM_CPTY_TYPE)=Forms!frmBemExceptions!bemCptyType Or ISNULL(Forms!frmBemExceptions!bemCptyType)) And ((BEM_EXCEPTIONS.BEM_VALUE_DATE) Between Forms!frmBemExceptions!bemValueDateFrom And Forms!frmBemExceptions!bemValueDateTo Or ISNULL(Forms!frmBemExceptions!bemValueDateFrom)) And ((BEM_EXCEPTIONS.BEM_DATE_TIME_CREATION) Between Forms!frmBemExceptions!bemCreationDateFrom And Forms!frmBemExceptions!bemCreationDateTo Or ISNULL(Forms!frmBemExceptions!bemCreationDateFrom)));

 

[ColinEssex]

Which field is showing the unexpected parameter box?

is it this one? - BEM_EXCPETION_DESC

Col