• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 196
  • 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 Access MVP)Database ArchitectCommented:
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 Access MVP)Database ArchitectCommented:
Not sure then what you mean by 'multiple screens' ?

mx
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
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 Access MVP)Database ArchitectCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

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