Need help with form view and datasheet view

[ConfusedMay]

I have a form that content all sales. Right now the default view is single form. the problem is that I can't view the form as a datasheet view when I run the form, even I already specified on the views properties allowed as both. but if I'm on the design view, I can change the view from form to datasheet view, not when the form is load as a startup form. Could anybody please help? Thank you.

[missinglinq]

I'm afraid you're not the only one who's confused, May! Your post is not very clear.

If you have Datasheet selected as the Default View in your form's Property Box the form should open in Datasheet view when either clicking on it in the Objects Dialog Box or when having it open the database thru

Tools -- Startup -- Display Page/Form.

If you open the form thru code in another form, you have to specify that you want it to open in Datasheet View by using acFormDS, regardless of how Default View is set for the form.

DoCmd.OpenForm "YourFormName", acFormDS, , stLinkCriteria

Post back if you have further problems.

Good Luck!

[ConfusedMay]

I'm afraid you're not the only one who's confused, May! Your post is not very clear.

If you have Datasheet selected as the Default View in your form's Property Box the form should open in Datasheet view when either clicking on it in the Objects Dialog Box or when having it open the database thru

Tools -- Startup -- Display Page/Form.

If you open the form thru code in another form, you have to specify that you want it to open in Datasheet View by using acFormDS, regardless of how Default View is set for the form.

DoCmd.OpenForm "YourFormName", acFormDS, , stLinkCriteria

Post back if you have further problems.

Good Luck!

Thank you for the reply and sorry for the confusion. What I need is the first time the form is loading, I need it to open as a form view (that's why I used the default view as single form.) Then, I want user to be able to view it as datasheet view by just going to view tool bar and datasheet view ( to do this I used the view allowed property as both) But when the form load, I'm not able to open it as datasheet view. The option on the view tool bar is gray out. Could you please help me? is there a code that say, view form allow and view datasheet allow?