Issue with seach fields in form

[Cheryl_Granieri]

Hi,

I have a form with 3 search fields. When hit the "search" button after plugging in the values I want to query, I am getting a pop-up box requesting that I enter the parameter values that I want. -Forms!mainform!permitstate-
Once I enter them, I the query runs correctly. I am not sure what I am missing with the connection of the query to the form. The query fields are linked to the form.

This is the code I have when I run hit the 'seach' button.
Private Sub cmdSearch_Click()

Me.SubformBasedOnQuery.Requery

Me.MaterialCode = ""


Me.Permitstate = ""
Me.RestrictedState = ""

If IsNull(Me.SubformBasedOnQuery.Form!Material_Code) Then


MsgBox "Material Code Not Found"


End If



End Sub

[June7]

Try:

Forms!mainform.permitstate

Your form is actually named 'mainform'?

If you want to provide db for analysis, follow instructions at bottom of my post.