We help IT Professionals succeed at work.

ms access forms

Shen
Shen asked
on
204 Views
Last Modified: 2012-08-14
Can ms access open from the same form multiple screens or do you have to create a form for each different screen?

Comment
Watch Question

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
The answer is Yes ... and here is a great example of how to do it:

Managing Multiple Instances of a Form
http://www.allenbrowne.com/ser-35.html

mx

Author

Commented:
Looking at your example it looks like this is to open the same form multiple times. My questions is really opening multiple screens with different fields or styles (like a single form screen and a continous form screen)  from the same form.  
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
Not sure then what you mean by 'multiple screens' ?

mx

Author

Commented:
Screen1 and 2 come from the same form but they are different.
--------------------------------------------------------
screen1 (form name: client)                        

 site: __________
 department: __________

 dc# number (button) - call screen 2
 s/n number (button)

-------------------------------------------------------
screen2  (form name: client)

 site    dc
___   ____
___   ____
___   ____
Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Commented:
I think that the easiest way to do that is to make screen1 and screen2 as two separate forms. Then create a main form and make the two "screens" its subforms.

Depending on your setup the main form can either be a bounded or unbounded form. I'd suggest using unbounded forms and then use vba to navigate the subforms.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.