It is not a good idea to give users direct access to queries or tables in
datasheet view in an application -- there are too many things that can
accidentally be done wrong. I suggest you consider creating forms for
displaying and handling the data and using the queries as the forms' record
source. But, if you are determined to use datasheet view, you can use either
a macro or the VBA DoCmd.OpenQuery or DoCmd.OpenTable.
Larry Linson
Microsoft Access MVP
"ogilby1" <og*****@insightbb.com> wrote in message
news:wxsdb.450086$cF.144726@rwcrnsc53...
Does Access allow a query to be listed on the switchboard?
Does Access allow a table to be opened in datasheet view from the
switchboard?
I have an application where users enter new data, print reports, (based on
a parameter query), and edit previously entered data in form view.