Dear Forum,
I have a small knowledge of Access and have created a simple database. I'm trying to set up a switchboard that opens a couple of forms built on a simple queries. The forms use criteria lookups from the query to select the criteria and shows the data in query datasheets.
The problem is the switchboard/form always remains on top of the queries when they run. The forms, not the switchboard, are set to close once they open the queries.
I have set both "pop-up" and "modal" to no in the properties and tried to set the focus to no avail. Nothing I do, or have researched, stops the switchboard remaining on top.
I'm looking for a very simple solution as I don't know how to use VBA.
Thanks for any help.