AboutRichard Rost Expertise I am happy to answer any kinds of questions about Microsoft Access - from basic table design to advanced VBA programming. Also, please feel free to check the Access Tips & Tricks section of my web site.
Education/Credentials I am a self-taught Access expert. I have been building databases for clients since the early 90s. You can see a sample of my Access Tutorials on my web site at 599CD.com
I have 5 forms in Ms Access 2003 and want to embed them into one main form and use back and fort arrow to enter data in each form, how I can do that? I would like to join all forms so by clinking one arrow to go to another form. I am not sure if I have to learn VBA or not. Your comments would be highly appreciated.
Answer Yeah, you'd probably need a little VBA for this. I would suggest making 5 subforms and then make a command button to simply SHOW and HIDE the subforms based on which one is active. Something like:
If SubForm1.visible = TRUE then
SubForm1.visible = FALSE
SubForm2.visible = TRUE
elseif SubForm2.visible = TRUE then
SubForm2.visible = FALSE
SubForm3.visible = TRUE
elseif…
And so on.
Let me know if you have any other questions or comments.
P.P.S. I volunteer my time at AllExperts to help people, and I get a LOT of questions, so I can't take an hour to answer each question. If you need more DETAILED HELP, come to my TechHelp web site at http://www.599cd.com/TechHelp/AllExperts and I'll take as much time as you need to answer your question.
