Run a query in a form from the switchboard?

[Chris Burnette]

Does anyone know how to open a query from the switchboard and have the
results displayed on a form? I figured out how to have a button on the
switchboard open a query, but it always opens it in datasheet view, which I
don't want the users to have access to lest they copy the data.

Does anyone know how to do this?

Any responses would be appreciated.

Thanks,

Chris

 

[Rick B]

Quit posting this same question in different newsgroups. ONE post per issue
please.

 

[fredg]

Does anyone know how to open a query from the switchboard and have the
results displayed on a form? I figured out how to have a button on the
switchboard open a query, but it always opens it in datasheet view, which I
don't want the users to have access to lest they copy the data.

Does anyone know how to do this?

Any responses would be appreciated.

Thanks,

Chris

Simply create a form which uses the query as it's record source.
Have the switchboard open the form.

 

[Chris Burnette]

Thanks Fred, I tried that and it works. The only issue I'm having now is
that when I open the form with the query as the data source, I get #Name?
entries in all of the fields that I have not included in my query.

I think the application is doing this because it cannot find a data source
for these fields, however the whole point of using a query is that I do not
want the users to be able to view those fields.

Does anyone know how to run a form with a query as a data source without
getting the #Name? entries for non-selected fields?

Thanks,

Chris