Updating multiple forms simultaneously

[Mark S]

Thanks for your help in advance.

I am using Access 2002. I have created about 10 forms each with two
subforms. They are based on two tables related by the same account number -
a Patient ID that has basic demographic information and a VisitID that has
information from each visit. You would see the same basic pt demographics
with 2 subforms that describe i.e. the heart and lung details.

When I open i.e. one form I identify the correct patient through a combobox
that goes to that person's record. I have 10 similar forms. What I would
love to do is identify the correct patient and then open any other form with
the correct person showing. Right now I must use the combobox to find the
right person after opening every form. I haven't a clue if you could
coordinate the identity of a patient so it would always open the correct
person and wouldn't change until you told it to.

If I could put twenty subforms related to one form it would work but I
didn't think you could do that. Even if you could you would scroll forever
from one subform to the next subform. If it would help to see the database I
could place it on my Web site.

Any suggestions are appreciated

*****************************************
Mark M Simonian MD FAAP

 

[Duncan Bachen]

If I could put twenty subforms related to one form it would work but I
didn't think you could do that. Even if you could you would scroll forever
from one subform to the next subform. If it would help to see the database I
could place it on my Web site.

Any suggestions are appreciated

Mark,

What you could do is to allow your primary form to open a popup form for
each of the 20 different kinds of things that you track. This is a UI
change, but might be necessary given your situation.

One way would be to have 20 different command buttons, labeled Heart,
Lungs, etc. Another way would be to have a combo box with all the
possible choices. Both of these methods are based on the 'show it when
you need it' principal. Don't open all 20 forms at one time when all you
need to do is look at one of them.

You can do this by setting the filter on the popup form when you open
it, equal to the PatientID.

You can let the form wizard design this for you if you want to see the
basic syntax and then adapt it from there. Or build it from scratch if
you're comfortable with the VBA.

 

[Mark S]

I may not have designed the orientation correctly now but have created a
separate form (like a menu or switchboard) to hold the command buttons to
each one of the forms (10) (each form holds the subforms)

I had built it in this way so any time you wish to edit the detail in the
subform you always see the correct basic patient demographics. It only
requires that you use a combobox to find the correct record. Although I am
not likely to need all the forms on any one visit I would have wanted to not
do this extra step each time (Click the Combobox to identify the correct
patient).

Let me think about what you are saying and see if I created an unnecessary
extra step in the design.

--
*****************************************
Mark M Simonian MD FAAP
681 Medical Center Dr West #106
Clovis, CA 93611
(559) 325-6850
www.markmsimonian.medem.com

 

[Guest]

There are three ways I can see for you to proceed.

The quickest would be to place the combobox that selects the patient on the
form with the command buttons. Now, wherever you referenced the combobox in
each form, you instead reference the combobox on the command buttons form:

[Forms]![NameOfCommandButtonsForm]![NameOfCombobox]

Another option would be to base the patient record that is shown on the
patient record already shown on the already open form. Now, wherever you
referenced the combobox in each form, you instead reference the control on
another form that contains your unique Patient ID. ie
[Forms]![NameOfYourMainPatientForm]![PatientID]. The disadvantage of this is
that it would require you to have a form open all the time.

Another option is to have all the subforms on one form (like you'd already
considered). But have one on top of the other and alter it's Visible
property. So, on the click event of one of your buttons, you would have:

[Forms]![MainForm]![Subform1].Visible = False
[Forms]![MainForm]![Subform2].Visible = True
[Forms]![MainForm]![Subform3].Visible = False

Then for another button it would be:

[Forms]![MainForm]![Subform1].Visible = False
[Forms]![MainForm]![Subform2].Visible = False
[Forms]![MainForm]![Subform3].Visible = True

etc etc.

Let me know if you need more detail.

Dave

I may not have designed the orientation correctly now but have created a
separate form (like a menu or switchboard) to hold the command buttons to
each one of the forms (10) (each form holds the subforms)

I had built it in this way so any time you wish to edit the detail in the
subform you always see the correct basic patient demographics. It only
requires that you use a combobox to find the correct record. Although I am
not likely to need all the forms on any one visit I would have wanted to not
do this extra step each time (Click the Combobox to identify the correct
patient).

Let me think about what you are saying and see if I created an unnecessary
extra step in the design.

--
*****************************************
Mark M Simonian MD FAAP
681 Medical Center Dr West #106
Clovis, CA 93611
(559) 325-6850
www.markmsimonian.medem.com