automated entry of parameters?

[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.

 

[Mark Hyland]

Hi,

You could create two combo boxes on a form, which show the values for the
two fields (Posture and Pasture), and then in the query, refer to the
fields on the form, for the criteria.

Your criteria would be something like

forms![formname]![fieldname]

This way, when the form is opened, the value you select will pass to the
query and act as a filter.

Hope this helps

Mark

This information is provided "as is" and expresses no warranties or confers
no rights.