Paramater Query (2002(XP))

Topic

New Reply

Is there a way you can have a Paramater box bring up a Pull Down Menu and you can select items from an existing Field?

Reply | Quote

Replies

If you mean the parameter window that is the standard result of a parameter query – no, not that I am aware of. To do this, use a dialog form instead. Make an unbound dropdown box on the form and use the value chosen in that box in the criteria row of the parameter query. As in: [Forms]![YourDialogForm]![YourDropdownBox]

Reply | Quote