Hello,

(yet)another query. I have created a parameter query that will run when a macro is run on a form. Can someone help me by telling me how I can change the relatively boring 'enter parameter value' box that pops up into a form?

Many thanks,

Sonya B

Use the expression builder to build the criteria specified on a form, that is, you have an open form which has the criteria. Be sure to have the form open (design or normal view) when building the query criteria with the expression builder.

You could have an unbound field on your form. In this field you would type the criteria that the query will ask for. Then use your macro to run the query. For example if your query reqires a date then you would have an unbound field call MyDate on the form. In the Criteria field of your query you would put [Forms]![YourFormName]![MyDate]. When you run your query the query will get the Date from the MyDate field on your form and you will not see any parameter request...