PDA

View Full Version : Enter Parameter Value Box As List Box



GaryB
04-28-2006, 10:34 AM
Hi,

I have a report that is linked to a query. In the query I have the criteria, set to ask me for the account and also for the item wanted. What has me stumped is how to have the value box for the item appear as a list box with multiple items to choose from. Any help would be greatly appreciated.

Thanks,

Gary

OBP
04-28-2006, 02:47 PM
This is normally done on a form, using a list box or preferably a combo box and the delected value is passed to the criteria row of the query or as SQL.