List Boxes

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I'm trying to set up a form that basical has three list boxes on it. in the
1st one you select manufacturer which then lists only the models from that
manufac in the 2nd list, then you select the model from the 2nd list which
then displays the part list for that model in the 3rd list & when you select
the part a subform would display all the relevant info on just that part
etc.

the 1st list box works great but the 2nd does not
all the relevent information is contained within the table etc

any help would be great

Thanks

Mike
 
Hi Mike:

Make sure that in the AfterUpdate event of the first listbox you requery the
second list, then in the AfterUpdate event of the second, you requery the
third.

You also need to be sure that the rowsource query of the second list refers
to the first listbox control (likewise for second and third).

Here's a KB article that describes how to synchronize two combos - the
technique is the same for a list box post back if you need more help or
further explanation. Be sure to include the SQL for your rowsource queries
and the names of the relevant controls and fields.

How to Synchronize Two Combo Boxes on a Form
http://support.microsoft.com/default.aspx?scid=kb;EN-US;289670

ACC: How to Synchronize Two Combo Boxes on a Form (97624)
http://support.microsoft.com/default.aspx?scid=kb;[LN];97624
 
Back
Top