Solved

saving current form, refreshing and staying on the record you are viewing on the different forms?

Posted on 2012-03-12
7
386 Views
Last Modified: 2012-06-27
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?
0
Comment
Question by:dkim18
  • 4
  • 2
7 Comments
 
LVL 77

Assisted Solution

by:peter57r
peter57r earned 150 total points
ID: 37710517
I don't think there's much you can do if you continue to use the Refresh button on the ribbon.  You have no means of getting inside that process.
(The problem is due to the fact that Refresh is not really refresh - it performs a Requery, not a Refresh.).

To get control over the situation you have to build your own Refresh procedure and if you want it to be always available then you will have to build your own custom ribbon to trigger it as well - unless you have a form that is always open and where you could place a Refresh All button.
0
 

Author Comment

by:dkim18
ID: 37710577
I think this only happens when you are creating a new record.

To propagate the data you just created from one form to other forms, I use the refresh all, is that right?
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37710869
<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
.
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:dkim18
ID: 37710990
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?
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37711242
Something like this:
Database93.mdb
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37711251
And keep the "Multiple forms open at a the same time" stuff down to a *minimum* and simply avoid these issues altogether...
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 350 total points
ID: 37711264
My pointy here is that if you used a Main subform this would not be an issue...
(simply enter the child data into the subform)

As soon as you want to allow: "Multiple forms open at a the same time"

Then managing this can get complex and messy relatively quickly...

JeffCoachman
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now