Using MS Access/Ms Access
Expert: Richard Rost - 7/8/2009
QuestionHi Richard,
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.
AnswerYeah, 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.
Also, be sure to visit my web site and watch my FREE 90-minute MICROSOFT ACCESS VIDEO TUTORIAL. Go to
http://www.599cd.com/Access/AllExperts
Cordially,
Richard Rost
599CD Computer Training
http://www.599cd.com
P.S. Also, don't forget to visit my FREE Microsoft Access Tips & Tricks Page at
http://www.599cd.com/Tips/AllExperts
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.
http://www.599cd.com/Microsoft_Access_Tutorial?key=AllExperts
Out of work? Know someone who is? Get a FREE copy of my Computer Job Skills CD at
http://www.599cd.com/JobSkills?key=AllExperts