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

creating a form that can select items and print them

P: 107
If I create two list boxes in microsoft access form.
The first list box lists Toyota, Honda, and Nissan.
The second list box depending on the first list box choice will list the models of car for that car.
example first list box choose: Toyota
second list box shows a list Corrola, Solara, Camry, and Tacoma.
Is there a way to make 3rd box and only add the models you want from the 2nd list box?
like Camry and Solara?
I have looked at cascading list boxes and cannot see how to do it?
I actually am trying to do something like the form wizard does when you create a form.
my last step i want to print out choices only I have made
Thank you
Dec 19 '08 #1
Share this Question
Share on Google+
4 Replies

Expert Mod 15k+
P: 31,491
The answer is "Not easily".

That is you could read the selected values from the .Selected array of the ListBox control and form those items into a filter string (of the form
Expand|Select|Wrap|Line Numbers
  1. [Make]='Toyota' AND [Model] In('Celica','Camry')
where 'Toyota' comes from the first ListBox and the 'Celica' and 'Camry' come from the second).

Have you seen Example Filtering on a Form? That may also give you some helpful ideas.
Dec 22 '08 #2

P: 107
thank you - I am looking at what you suggested now-
Dec 22 '08 #3

Expert Mod 15k+
P: 31,491
No worries - I hope you can make sense of it all :)

Certainly there are some useful concepts in there so you'll probably benefit from the exercise if nothing else.
Dec 22 '08 #4

P: 675
I am attaching a simple program that does what is asked for here. It does not check for no entries or other errors, and will error if buttons are pressed when inappropriate.
This does build a list in a listbox based on selected items in another listbox. This is not a cascading combobox problem, although the first selection by user is in a combobox.
Table items per examples in initial post.

Dec 22 '08 #5

Post your reply

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