Datsheet view

[Knew2]

I created a query (from 1 table with 3 fields). I then created a form based
on this query and want to view the form as a "datasheet". When I view the
form in the databse window it shows as a datasheet but when I try to call it
up from a button on a form it will not come up as a datasheet but only as a
continous form
Form properties:
Default View: Datasheet
Allow datsheet view: yes
All other views no.....
Not sure what I am missing???

 

[Chad]

Try this in your button.

DoCmd.OpenForm "YOUR FORM", acFormDS

 

[Knew2]

Thanks.......

Try this in your button.

DoCmd.OpenForm "YOUR FORM", acFormDS