Run a query from switchboard in a form?

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
 
R

Rick B

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

KAFES

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
 
C

Chris Burnette

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...
 
Top