By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,789 Members | 1,447 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,789 IT Pros & Developers. It's quick & easy.

Need help with form view and datasheet view

P: 57
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.
May 21 '07 #1
Share this Question
Share on Google+
2 Replies

missinglinq
Expert 2.5K+
P: 3,532
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!
May 22 '07 #2

P: 57
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?
May 22 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.