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?

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

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

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!frmBem Exceptions!bemDescription Or ISNULL(Forms!frmBemExceptions!bemDescription)) And ((BEM_EXCEPTIONS.BEM_GROUP_ID)=Forms!frmBemExcepti ons!bemQueue Or ISNULL(Forms!frmBemExceptions!bemQueue)) And ((BEM_EXCEPTIONS.BEM_PRIORITY)=Forms!frmBemExcepti ons!bemPriority Or ISNULL(Forms!frmBemExceptions!bemPriority)) And ((BEM_EXCEPTIONS.BEM_STATUS)=Forms!frmBemException s!bemStatus Or ISNULL(Forms!frmBemExceptions!bemStatus)) And ((BEM_EXCEPTIONS.BEM_ENTITY)=Forms!frmBemException s!bemEntity Or ISNULL(Forms!frmBemExceptions!bemEntity)) And ((BEM_EXCEPTIONS.BEM_CPTY_ID)=Forms!frmBemExceptio ns!bemCptyID Or ISNULL(Forms!frmBemExceptions!bemCptyID)) And ((BEM_EXCEPTIONS.BEM_CPTY_TYPE)=Forms!frmBemExcept ions!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) ));

Which field is showing the unexpected parameter box?

is it this one? - BEM_EXCPETION_DESC

Col