Create a query from a form

[Triscia]

Is it possible to run a query from a form. I have a database that someone has created and I am trying to run a query from it. I ultimately want to create a Switchboard for users to use which is easier when they are trying to locate their specific records. TIA.

[June7]

What do you mean by 'run a query from a form'. A SELECT, UPDATE, INSERT, DELETE? Code can open a query object. Users should not even see tables and queries, only forms and reports.

[Triscia]

I thought that queries had to be run from a table and not a report. When I go to set up a query it asks from what table or query. The problem is the person that designed the database didn't create a table, they just used a form that downloads from a website. I am trying to make it so users do not have to look at all the unnecessary data, only data that pertains to them. I am ultimately trying to set up a switchboard to make it even easier on them. The person that set up the database has all the tables, queries, reports and forms available for people to see. I think that is too confusing for people who are not familar with access. Thanks appreciate any help!

[June7]

The downloaded info is fed directly into unbound textboxes on an unbound form? If so, then it isn't saved anywhere. Close the form and the data goes away.

Queries can be opened/run by code behind forms or reports. Forms and reports use tables, saved queries, or SQL statements as their RecordSource.

The navigation pane can be hidden and shortcut menus can be disabled. The ribbon can even be modified to not provide design tools. However, be aware that without some extreme measures, those settings can be overridden by holding the shift key while opening the db.