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

trying to create a list in a subform thats restricted based on info entered in form

P: 2
Hi There,

Sorry Im a newbie to access and hate reading through pages of text, hoping someone can help.

Within the main form, users key in details of an order including supplier details. Within the subform there is a list of products to choose from. I want to limit the list of products in the drop down list to those supplied by the supplier number keyed in the main form.

How would I do this?
May 10 '07 #1
Share this Question
Share on Google+
1 Reply


JConsulting
Expert 100+
P: 603
Hi There,

Sorry Im a newbie to access and hate reading through pages of text, hoping someone can help.

Within the main form, users key in details of an order including supplier details. Within the subform there is a list of products to choose from. I want to limit the list of products in the drop down list to those supplied by the supplier number keyed in the main form.

How would I do this?
Is this a duplicate?

set the rowsource for your combo box

Select whatever from yourtable where ID=" & me.parent.ID & ";"

J
May 11 '07 #2

Post your reply

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