how do i open a form in datasheet view?

  • Thread starter Thread starter Rani
  • Start date Start date
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 ?
 
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-----
 
Rani,
When opening a form from an event, you must specify datasheet view,
otherwise it will open in form view:

DoCmd.OpenForm "FormName", acFormDS
 
Back
Top