To set the values of parameters in VBA, you use the syntax as shown in the picture below.  The key thing is that the user won't be able to manually enter the parameter value as you usually do.  The parameter value has to be fed into the query with VBA code as shown in the picture, otherwise you get a run-time error.  Therefore, if you must get an input from the user, you need to do it some other way, such as with the InputBox() function or other form operations.

P.S. Richard would never say this, but if you were my student, I would say that parameter queries are to be avoided.  They cause problem with VBA coding such as this, because user input cannot be used.  You have to get the user's input some other way.  And if you can't have user inputs, you might as well just use regular queries, and avoid parameter queries altogether.  All the domain aggregate functions (DLookup, DMax, DCount, etc.) also don't allow parameter queries.

Value From a Form

Oh, I agree with you, Kevin, that parameter queries are to be avoided - for professional developers. For beginners, it's an easy way to teach them how to specify criteria. For pros, ABSOLUTELY avoid parameter queries.

Shia, what I would recommend you do is instead of creating a query, just create a form with fields for your user to specify the criteria you want, and then build the SQL statement in VBA, and then use that to set the RecordSource property of your form (or another form). See Search Form 2.0 or Access Search Seminar.

Thanks Richard,You've been the voice I hear most frequently these days