automate parameter entry?

  • Thread starter Thread starter JR
  • Start date Start date
J

JR

I gather and disseminate data for several different
customers whose requirements for the same data elements
varies with the model they are feeding.

One table is set up as follows:

Org ID | Location | POSTURE | PHASE | Rate

Posture and Phase are variables with 5 and 4 possible
variables respectively which give 20 possible combinations.

I must periodically rebuild the table data. I use an
append query to do that BUT the query design is such that
Posture and Phase are expressions (1 and 2 respectively).
Each time I update the table I am prompted to enter
parameters for the two expressions (Posture and Phase).
There has GOT to be a better way (such as using a form
that allows me to select the combinations of Posture and
Phase from a list).

Any help will be greatly appreciated.
 
You can use a form to do this. Create a blank form and
add to it two fields that are both drop down boxes.
Populate the values with the ones that you will be
choosing from. Make sure you name each combo box in its
properties. Then create a button to run your query. In
your query instead of the prompt for the values you will
have it directly look up what is entered into the form in
the following format: [forms]![formname]![fieldname]. As
long as the form is open, the query will automatically
look here for your entries. Hope this helps!

Jessica
 
Back
Top