Enter Parameter Value?

[LordMaximus]

Hi people

DB is as follows. I've created a Search FORM that has a dropdown box with data i get from one of my tables (SQL Query)

I then have a line in my code that reads :

Private Sub cboSearch_change()
DoCmd.OpenQuery "Input_table Query"
Me.cboSearch = ""
End Sub

The Query Input_table Query then has a Search criteria of [Forms]![Srch1_form]![cboSearch].

Everything works fine except, when i click the Dropdown in rutime mode on my search form, i get this little Inputbox that Reads "Query2.Problem description" and the title of the input box is "Enter Paramater Value"

When i type anything in the box and click ok, it goes through and everything works fine as it should.

How do i disable this little popup box?

Thanks

 

[hermanlaksko]

Somewhere in your dropdownbox or in connex with the "input_table_query" you have a ref to the query "Query2"

Herman

They say that crime doesn't pay... does that mean my job is a crime?