How to populate a continuous form based on a combo box?

[bakkouz]

I need to build a form, which is basically a maintenance form. the user selects the location from a combo box and is then presented with a subform/continous form containing the items/action taken/date...etc.

I have built the form/tables containing the location/items using a form/subform ( continuous form). it looks like this:

As you can see, it shows the cabinet and its contents. the user of course an add/modify cabinet names and contents as necessary, I managed to do this using the continuous form.


Now, what I want is the procedures form, which should look like this:

The user selects the cabinet from the combo box and the top, and in the subform it shows the items inside the cabinet which extra fields for date/action... etc.


So, How do I go on about doing this?

Thanks.

[zmbd]

These articles cover the basics of filtering and cascading combo boxes and/or the basic parent/subform agrangement is what I think you're after here:

• Microsoft Access / VBA Insights Sitemap
• How to select Records in an Access Subform from a Combo Box
  
• Cascaded Form Filtering
• Multiple Combobox Filter with Clear Option
• Example Filtering on a Form.

These can be heavy reading; however, please don't give up if you get stuck, we're here to help explain! (^_^)