Grab a value from a label to put for critera for attached query

[Guest]

Let me give a little background of table/query structure.

I have a query that pulls jobs due Today-now() whose frequency is for today.
I have table with the following fields.
Job#, Location(ie.what Plant & Floor), Room(ie. mens washroom, storage room,
etc.), job Desc., Frequency, est. time, resp.. This table ties in to create
a query with another table - Cleaning(when the jobs are actually carried out)
Cleaningid, Date Done, Who did the job) and grabs the other fields from the
other table.

Here goes what I need to get:
The people on the floor will have a MAP of the floor ( Form) with just
Labels right now. Each Floor(Location) is its OWN map(with a label of the
location on top- just as a title) and each Room is a Label ON the form. When
they Open the form I would like to grab the Location and set it in the
criteria for the query to show what jobs need to be done in addition to what
Room they On Click on the Form - So once they pick the Room it will show all
jobs that need to be Done for Today!!. Not sure how to grab the location and
room and put them as Criteria in the query.

Thanks in advance for your help,
Barb

 

[Guest]

You can use an option group on your form and use it as criteria in the query.
The labels for the option group can be arranged to form your map.

You may need to also have a translation table joined to your data table in
the query.