parameter question

[GeorgeChr]

I have a query which have a column where the values are chosen by a drop down list box (the name is "level"). I want to create a parameter where when someone opens the query he will have to choose one of these values to see. instead of the common: please enter name for exapmle, I want to be like: please choose one of the following (and here comes the drop down menu).
thnx!

 

[KenHigg]

I'm guessing your best bet is going to be to create a small pop-up form to put your combo box on...


ken

 

[GeorgeChr]

what do you mean create a small pop up form?? I have to create o form based on the query first and then that? forgive me if i'm asking silly questions, i dont have experience..

 

[KenHigg]

Are you adding data from a form or in table view?

 

[GeorgeChr]

from a form

 

[KenHigg]

I'm getting confused. You have a form. The form is based on a query. You enter data in the form. On one of the fields you want to allow the user to select available input options from a combo box. Is all of this correct?

:
ken

 

[GeorgeChr]

Sorry I got u confused, let's start over. I have a query and one of its columns (name: Level) contains values that u choose NOT type (list box). I want to have parameter which prompts the user to choose one of these values. About the form, I have a form based on that query but as far as I know, the parameters should be created in the query design and then you have them in your form automatically.

 

[KenHigg]

Hum... Look at the 'Lookup' tab for the field in the table design view. It's at the bottom where you set up default values, formats and such for each field in the table...



ke