Dynamic Queries - Stop parameter popup

[damienwjking]

Hey,
I have a form based on a dynamic parameter query. The problem is I am still getting those anoying parameter popups when I open the form.

The code im using in the query is like this,

LIKE '*' & Form!frmRealSearch![txtFindDivision] & '*'

If I click ok on the the parameter popup it works fine. but I dont want the popup to display.
When the user opens the form I want the sub form to list all contacts and then if they want to can the query they can use the textboxes/combos to update it.

Does anyone know what im doing wrong or how to get rid of those popups.
thanks

 

[damienwjking]

You can all stop worrying. I just worked out its the syntax in my statement

LIKE '*' & Form!frmRealSearch![txtFindDivision] & '*'

forgot the "S" on FORM!

what a muppet.