Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 194
  • Last Modified:

ms access forms

Can ms access open from the same form multiple screens or do you have to create a form for each different screen?

0
Shen
Asked:
Shen
  • 3
  • 2
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)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
0
 
ShenAuthor 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.  
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Not sure then what you mean by 'multiple screens' ?

mx
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
ShenAuthor 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
___   ____
___   ____
___   ____
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
soooo, the Forms (screens) are kind of different ?
Keep in mind that ... re "open the same form multiple times." ... with each instance you  open, you can set / change specific properties, make controls visible/not visible, change colors, etc. Those can all be set independently for each instance ... on the fly when instantiating a given instance.

As far as  "(like a single form screen and a continous form screen)" ... you can also toggle the Form view in the paradigm above.

mx
0
 
SheilsCommented:
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.
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now