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.