Combos and Queries

[glenn91]

Hi,



I have been looking around this forum for a long time now and taken a lot of advice regarding building an access database which I really appreciate.

Recently I have been asked to create a new part to my database which is to basically track what a physical site is capeable of, such as wi-fi acccess, seats, tables, a wall for projector etc.

I have no issue storing this data the only issue I have ran in to is attempting to create a form for the query values so that team members can query the database themselves. The form I intend to create will have a subform that updates after each selection.

The way I would like the form to work is, if i select an Opertaions Director Region, this would then show the Regions within the OD Region, this would trickle down to Facility level. So once the region has been selected it would show the facilities within this Region.

I understand that cascading combos would be the best job for that, however the issue i run into is when i would like to also query on the capabilities of the site. So if a user had selected Yes for wifi and Yes for Chairs but left the remaining blank or a * that this would still query without issue.

I hope this makes sense.

Thanks,

Glenn

[June7]

Selecting multiple criteria for a single field does complicate and will likely need VBA code.

Review
http://www.allenbrowne.com/ser-62.html
http://allenbrowne.com/ser-50.html

[orange]

Perhaps you could show us your tables and relationships to help understand where this would fit.

[glenn91]

Hi June7 & Orange,

As the VBA coding was necessary for this to work I have opted for an alternative approach of using cascading combos to select the location and a series of parameter prompts for the physical site items.

Many thanks for your suggestions, I will one day begin to learn to code.

Thank you,