Using checkboxes on forms to modify query parameters (1 Viewer)




I am trying to create a query/form relationship which will allow the user to tick a number of checkboxes (anywhere between one and eleven boxes selected). The checkboxes that are selected will then modify query parameters to return only those records that have the SAME checkbox selected in another form.

To simplify; i have a database containing a number of records detailing equipment installed in a number of rooms. Each item of equipment has an assigned checkbox in each record which is checked/unchecked depending on if this room has the equipment installed.

I then wish to allow a user to display a list of rooms containing certain equipment by selecting (via a series of checkboxes on a form) which items of equipment they wish to search for.

Any assitance appreciated. I'm just working myself into a mess trying loads of different approaches at the moment.



Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom