How does one Place the Same Data; concurrently, on 3 open forms? 1

[prawdzik]

Hi!
I am using a single table. I have 1 form acting as my switchboard which opens up 1 of 3 forms. The 3 forms use unique queries as the recordsources. I want to open either form, add a new data record, and automatically have the client name be entered on the same data record on the other 2 forms (without closing the first form). I am trying to switch between all 3 forms - while leaving them all open, and I will close all of them when the forms are completed.

The problem for me is that when I go to another form, after entering client name on the 1st form, the forms don't seem to be synced-up. On each forms' OnActivate, I use the Goto record number I saved from the first form.

The ? is, what do I need to do to have the client name show up in the other forms, when the rec number on each form is set to the same rec number as the 1st forms' new record number?

Thanks for your help!

 

[JerryDennison]

Would a tabbed form be more appropriate? Not knowing the structure of your data it is difficult to give you specific advice. Tabbed forms are great ways to organize your data entry into different but related "sections".

 

[Aivars]

Hi!
If all three forms are opened you may requery not focused forms.

On the supposition that you're updating form1:

dim frm2 as form
dim frm3 as form

set frm2=forms!form2 'Or Forms("Form2Name&quot
set frm3=forms!form3 'Or Forms("Form3Name&quot

sub form_afterUpdate
frm2.requery
frm3.requery
end sub

Aivars