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

Populate 2nd list box from 1st list box choice

P: n/a
I have 1st list box from table Grain
2nd list box from related table Varieties, related by GrainID

At the moment Grain listbox is on its own form and Variety listbox is on
subform in Grain form.
Variety form has all the costing records related to it in another subform.
(3 deep)

This all works for except that all the records in Variety are shown. By
seleting Grain
and then select Variety i get the correct results in the Costs subform.
What i would like to do is only show records in Variety listbox that relate
to the choice
made in Grain listbox

2 things
is it possible to have the 2 listboxes on the 1 form with 1 Costs subform?
how do you get the Variety listbox to only show Varieties related to the
Grain choice?
Any help would be greatly appreciated


Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
See:
Limit content of combo/list boxes
at:
http://www.mvps.org/access/forms/frm0028.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"John M" <jo*****@bigpond.com> wrote in message
news:RW******************@news-server.bigpond.net.au...
I have 1st list box from table Grain
2nd list box from related table Varieties, related by GrainID

At the moment Grain listbox is on its own form and Variety listbox is on
subform in Grain form.
Variety form has all the costing records related to it in another subform.
(3 deep)

This all works for except that all the records in Variety are shown. By
seleting Grain
and then select Variety i get the correct results in the Costs subform.
What i would like to do is only show records in Variety listbox that relate to the choice
made in Grain listbox

2 things
is it possible to have the 2 listboxes on the 1 form with 1 Costs subform? how do you get the Variety listbox to only show Varieties related to the
Grain choice?
Any help would be greatly appreciated

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.