Disabling or By-passing a Parameter Query CANCEL button

[Tom Evans]

In MS Access I have a Parameter Query asking for a Job Number and then the data retrieved populates a Form.
When the Parameter Query window surfaces you now have 2 choices after entering the Job Number these are pressing “OK” or “CANCEL”.
If OK is clicked the Parameter Query works perfectly and populates the Form.
If CANCEL is clicked the Parameter Query does not cancel and continues to run but then cannot populate the Form because it has no data and therefore gives errors.
My question is, is there any way to de-activate or by-pass the CANCEL button?

[pbaldy]

Most of us use a form to gather user input; it gives you a lot more control. To your question, I don't think so.

[ranman256]

instead of param query, make a form that shows all data,
put UNBOUND controls on the header area for it to filter the data, user then clicks FIND btn which checks the controls on what to filter:

Public Sub btnFIND_Click()
Dim sSql As String, sWhere As String


sWhere = "1=1"


    'the query is built depending on the various filters the user picks...
If Not IsNull(cboState) Then sWhere = sWhere & " and [state]='" & cboState & "'"
If Not IsNull(txtName) Then sWhere = sWhere & " and [Name]='" & txtName & "'"
If Not IsNull(chkContact) Then sWhere = sWhere & " and [Contact]=" & chkContact.Value


 'use it to filer the form records
if sWhere = "1=1" then
  me.filterOn = false
else
  me.filter = sWhere
  me.filterOn = true
endif
END SUB