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

Creating Page in the Form View

P: 9
I am developing a database and want to create multiple pages in the form view. I have typed all the questions in the table but and created form by using wizard and it gave me a HUGE big form. 150 questions in one form does not look good. I want to create 5 pages in the form view to help the entry operator and to make it look better. After entering data into first page the entry operator should be able to hit next and the next page should pop up, and then third, fourth and fifth.

I don'ty know how to do that. I have tried with 'Create data access page by wizard' but could not progress much.

Any help?

Thanks
Aug 14 '06 #1
Share this Question
Share on Google+
2 Replies


100+
P: 179
One way of making it more presentable is, instead of having 5 pages, set up a form as a single form. You can then scroll through the questions one by one.

You can also put a Command Button on the form with a textbox beside it, and enter a number in the textbox, click the button and have the form go to that question. The code for the Command Button would be (this is the OnClick Event):

Private Sub Command20_Click()
DoCmd.GoToRecord acDataForm, "FormName", acGoTo, Me.TextboxName
End Sub

comteck
Aug 15 '06 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
Another way of doing this is to drag the Multi Page control from the toolbar onto the form. However, if you do this you will have to reset each page individually with the various controls. You can't just drag them on from the form.


I am developing a database and want to create multiple pages in the form view. I have typed all the questions in the table but and created form by using wizard and it gave me a HUGE big form. 150 questions in one form does not look good. I want to create 5 pages in the form view to help the entry operator and to make it look better. After entering data into first page the entry operator should be able to hit next and the next page should pop up, and then third, fourth and fifth.

I don'ty know how to do that. I have tried with 'Create data access page by wizard' but could not progress much.

Any help?

Thanks
Aug 16 '06 #3

Post your reply

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