how do i open a form in datasheet view?

R

Rani

hi guys I've created a form and I've set the form properties to allow only
datasheet view.
when I open the form from the DB design windows it pops ok.
when I open it from a on Dbl Click event of a field it opens in a normal
way.
what do I do ?
 
G

Guest

Edit the code in the double-click event procedure to read
as follows:

DoCmd.OpenForm YourFormName, acFormDS + any other
criteria.

The acFormDS opens the form in datasheet view.

Rgds,
Glenn


-----Original Message-----
 
F

Fredg

Rani,
When opening a form from an event, you must specify datasheet view,
otherwise it will open in form view:

DoCmd.OpenForm "FormName", 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

How do I clear a form? 0
Unremovable horizontal scroll bar on subform 1
Request Form - Alert Team Member 0
Form Default View - Datasheet 2
Form view Datasheet 1
Populate main form from subform record 0
Datasheet View 3
Prompting for Saving Changes in a Form in Datasheet View 2

Top