plsssss help - query

[Guest]

Hello!

I have a table that has rates based on weights of goods, which is
catagorized as rate1, rate2...rate6, based on weight codes which are
1,2,3,4,5,6.

I want to accept a number ranging from 1 to 6 from the user, who should have
an option to enter his choice of weight every time the query runs and get
rates pertaining to that record (corresponding to that weight only.)

pls help me - how do you accept a choice from user.
also how do you select records based on the weight code, which extracts only
the corresponding rate.

Thanks so much in advance

Rekha

 

[Guest]

You want the user to enter a value in a box, click a button and have a list
come up?

Within your query you'll need to enter Like
[Forms]![my_form_name]![my_control] in the Criteria cell in the column that
represents the 1-6 value. Where my_form is the name of the form that your
text box (my_control) is positioned.