asked on
saving current form, refreshing and staying on the record you are viewing on the different forms?
When my users work, they have multiple forms opened.
I asked them to hit the refresh all to save the current working record.
So this data can be propagated to other forms' lookup controls like combo box.
When they hit the refresh all, the current record from whatever opened forms got sorted and lost.
1) How can I save the current record on the working form without losing the location of the whatever forms they have opened?
2) When I add/edit on one form, I want that to propagated to other currently opened forms without losing their current location?
I asked them to hit the refresh all to save the current working record.
So this data can be propagated to other forms' lookup controls like combo box.
When they hit the refresh all, the current record from whatever opened forms got sorted and lost.
1) How can I save the current record on the working form without losing the location of the whatever forms they have opened?
2) When I add/edit on one form, I want that to propagated to other currently opened forms without losing their current location?
Microsoft AccessVisual Basic ClassicVisual Basic.NET
Last Comment
Jeffrey Coachman
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
<I use the refresh all, is that right?>
Well, if you tried it, did it work?
<the current record from whatever opened forms got sorted and lost.>
I have never "Lost" data by hitting the refresh all button.
As Pete states, this does a requery (that will bring you back to the first record typically), thus you will not be on the current record anymore.
But the record is not "Lost"
This is the reason most Access devs try to keep the number of open forms to a minimum.
Try to use Main/subforms instaed of standalone forms, where managing these things is easier .
Well, if you tried it, did it work?
<the current record from whatever opened forms got sorted and lost.>
I have never "Lost" data by hitting the refresh all button.
As Pete states, this does a requery (that will bring you back to the first record typically), thus you will not be on the current record anymore.
But the record is not "Lost"
This is the reason most Access devs try to keep the number of open forms to a minimum.
Try to use Main/subforms instaed of standalone forms, where managing these things is easier .
ASKER
Yes, the refresh all works.
I meant "Lost" as the newly created record got sorted and it is not the current working record.
I am already using the main/subform.
So what do you guys suggest for staying at the newly added record after the creating new record?
I meant "Lost" as the newly created record got sorted and it is not the current working record.
I am already using the main/subform.
So what do you guys suggest for staying at the newly added record after the creating new record?
Something like this:
Database93.mdb
Database93.mdb
And keep the "Multiple forms open at a the same time" stuff down to a *minimum* and simply avoid these issues altogether...
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
To propagate the data you just created from one form to other forms, I use the refresh all, is that right?