Default Form View Settings

C

cita

If anyone can help me I would appreciate it. How do I
save a form to open in the datasheet view only. I have
set datasheet view as the view to open in, in my form
properties, but upon click the form I want it still opens
it in form view format.
 
G

Graeme Richardson

Try these.
1) set the Views Allowed property to Datasheet (means that you can't swap to
Form view)
2) explicitly open the form in datasheet view: Docmd.OpenForm "MyForm",
acFormDS
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting a default zoom in Infopath 0
Only Files received through email are being blocked 0
Populate main form from subform record 0
Office Word JPEG in a document showing but not printing out 0
Filtered view of Visio Chart 0
Form State 2
Access 2013: Form problem in reading data tables; relationship one-to-one 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1

Top