By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,963 Members | 1,825 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,963 IT Pros & Developers. It's quick & easy.

I want to limit the products displayed in a drop down list to certain criteria

P: 2
Hi There

Im using access 2003 and have created a form for entering orders.

In the database I have a table of products which is displayed in a subform
Users have to scroll through large volumes of products and I'd like the drop down list in the subform to be limited to only those products that are linked to a particular supplier.

for example: Each order is given to us by a certain supplier, the supplier id is entered in the main form, when the user clicks into the subform, a drop down list of products is displayed, Id like the list to only display products that the supplier entered supplys

Can you advise the easiest way to do this
May 10 '07 #1
Share this Question
Share on Google+
1 Reply


JConsulting
Expert 100+
P: 603
Hi There

Im using access 2003 and have created a form for entering orders.

In the database I have a table of products which is displayed in a subform
Users have to scroll through large volumes of products and I'd like the drop down list in the subform to be limited to only those products that are linked to a particular supplier.

for example: Each order is given to us by a certain supplier, the supplier id is entered in the main form, when the user clicks into the subform, a drop down list of products is displayed, Id like the list to only display products that the supplier entered supplys

Can you advise the easiest way to do this
If the data is related, this is pretty simple.

in your combo box, click out to the right of the Rowsource property there's a ... there.
it will open a query window displaying your rowsource. Switch to SQL view and paste it in here and we can adjust it to include a criteria that looks at the main form's Supplier ID. This is assuming there's a linking field in your proucts table.
J
May 11 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.