populating a continuous form based on a combo box?

[bakkouz]

hey guys,
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 with extra fields for date/action... etc.

So, How do I go on about doing this?
Thanks.

[rpeare]

So you want the items on your PROCEDURES form to be limited to what you select in the CABINET combo box at the top of the same form?

You can set the RECORD SOURCE of the form to be a query where the critera of the query in the CABINET identifier field would be something like:

forms!frm_procedures!cbo_Cabinet

where frm_procedures would be the name of your procedures form
and cbo_cabinet would be the name of your UNBOUND control where the user is selecting the cabinet.