Expert: Richard Rost - 7/8/2009

Question
Hi 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.


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.

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