List Boxes

[E. Macalalad]

I'm designing a form that will utilize two list boxes to populate my data
table. In list box #1, let's say that I can choose from the following:

Item A
Item B
Item C

If I select Item A in list box #1, I would like list box #2 to display the
following:

Item A1
Item A2
Item A3

Likewise, if I selected Item B in list box #2, I would like list box #2 to
display the following:

Item B1
Item B2
Item B3

And so on. Items A1-A3 and B1-B3 are completely unique. I'm having a
difficult time trying to figure out how to proceed. Do I need a queries? Do I
need separate tables? Help!

Thanks,
E

 

[John W. Vinson]

On Tue, 14 Oct 2008 11:48:11 -0700, E. Macalalad <E.

I'm designing a form that will utilize two list boxes to populate my data
table. In list box #1, let's say that I can choose from the following:

Item A
Item B
Item C

If I select Item A in list box #1, I would like list box #2 to display the
following:

Item A1
Item A2
Item A3

Likewise, if I selected Item B in list box #2, I would like list box #2 to
display the following:

Item B1
Item B2
Item B3

And so on. Items A1-A3 and B1-B3 are completely unique. I'm having a
difficult time trying to figure out how to proceed. Do I need a queries? Do I
need separate tables? Help!

Thanks,
E

You need to base the second listbox on a Query referencing the first listbox.
What is the structure of your tables? Where are these items, and how does
selecting ItemA indicate what "more detailed" items are eligible?

 

[E. Macalalad]

I'm such a novice at Access, I hope I answer your questions in such a way
that I actually make sense.

So, I've created a form that allows the user to choose from the different
departments such as Manufacturing, Quality, Engineering, Business
Development, etc. (I've called this list box Department). When the user
chooses the specific department from the list box, the results are stored in
the main table, Lessons Learned.

From there, let's say if Engineering is selected, the second list box (let's
call it General Category) would provide a list like Equipment Design,
Equipment Procurement, Vendor Delivery, etc. I'm assuming that I probably
need to create another table for Engineering, as well as separate tables for
Manufacturing, Quality, etc. But I'm just not sure.

Does that make sense? Again, I'm a novice and don't really have much
experience with Access or VB programming, etc.

Thanks for the help and your patience!
E