Run a query from switchboard in a form?

  • Thread starter Thread starter Chris Burnette
  • Start date Start date
C

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.

Any responses would be appreciated.

Thanks,

Chris
 
Don't open a query, open a form. Base the form on the query so the records
will be filtered the way you desire.
 
Hey Chris,

Also, if you dont want the users to have the ability to modify data in a
query (or form based on a query), go to the query properties and under
general tab, find:
"Recordset Type" [default] = dynaset --- change to "snapshot" and the users
can not edit or add data to that query.... As Rick says, you can (and prolly
should) have a subform or main form based on that query, and the snapshot
property will still hold true ;)

HTH,
Mike
 
Thanks guys, good info.

-Chris

KAFES said:
Hey Chris,

Also, if you dont want the users to have the ability to modify data in a
query (or form based on a query), go to the query properties and under
general tab, find:
"Recordset Type" [default] = dynaset --- change to "snapshot" and the
users
can not edit or add data to that query.... As Rick says, you can (and
prolly
should) have a subform or main form based on that query, and the snapshot
property will still hold true ;)

HTH,
Mike




Rick B said:
Don't open a query, open a form. Base the form on the query so the
records
will be filtered the way you desire.
Click to expand...
Click to expand...
 
Back
Top