There are two ways of going about this in Access that I know of. I havn't written any Access code in 2003, but this should still work.

The first is to create a query that points to the fields of the form that contain the criteria. This is the old school way in Access, but if your doing something simple you might want to go this way.

To do this create a form with the fields you need, and save it. Then create a query and in the criteria field of the query right click and select the build option. Buried somewhere among the options is one to select a field from an existing form.

Then you just need to stick a button on the form to run the query. In this case it is usually DoCmd.OpenQuery "name of query", some options I can't remember.

The other way is using VB code like this. Line 3, 4 and 5 just show common ways of referencing the parameters.

Set Query1 = db.QueryDefs("Name of Query")
Query1("State") = "PA"
Query1![City] = "Lancaster"
Query1.Parameters(2) = "17601"
Set RecordSet1 = Query1.OpenRecordset()

Jay