Form / Datasheet code question

J

JP

I have a form that opens a datasheet. I have some VBA in
the datasheet that pulls a ID from the form. However,
whenever the datasheet opens, it is in form view. I've
checked it over and made sure Form View is set to "NO".
It is set to Datasheet view only. Any ideas??
 
A

Allen Browne

If you are using OpenForm, specify the 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

Populate main form from subform record 0
Access 2013: Form problem in reading data tables; relationship one-to-one 0
Insert Form in Page 0
Unable to extract records filtered in a datasheet - Access 2010 1
Form State 2
datasheet view 2007 without saving column layout changes 2
toggling view in a subform 0
ocx calander on a form with subform (datasheet view) 6

Top