automate entering parameter value

[JR]

I have an append query that requires the definition of
two "parameters" as it executes.

The problem is that each time I run it I have to manually
enter the two parameters. There are 20 different
combinations and so the query has to be executed 20
separate times.

Is there a way to automate the process?

The table it writes to is laid out as follows

Item ID | Alpha-Numeric
Location | Alpha
Posture* | Alpha
Phase* | Alpha
Rate | Number

*Posture and Phase are the columns that must be manually
entered as parameters when a pop-up prompt asks for a
parameter. The manual entry of that parameter is what I
want to automate. Entering the parameter pop-up populates
the Posture and Phase columns with the value entered.

Thanks,
JR

 

[Ken Snell [MVP]]

Use a form to hold the criteria for the query. Put textboxes on the form for
each of the criteria. Put a command button on the form to run the query.

In the query, change the parameter to
[Forms]![FormName]![TextBoxName]

Keep the form open while you run the query.