TextBox refresh only, or refresh current record

how to refresh a text box onLoad(), without using me.refresh or me.requery or me.recalc because they refresh the whole form and takes me to first record!!!  i tried several onCurrent events and so
ahashashAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
What is in the text box that you needs to refresh?
0
ahashashAuthor Commented:
some have integer values that are results of some datdiff functions, and some have strings, i would like to have the text box be updated onChange of these values AND  follows the current record, its like i move to the next record and the value is still the same so i had to make a button and press it in order to update that textbox, the best solution is to update the current record but using me.recalc and these things jumps the form to the first record!!!??
0
Jeffrey CoachmanMIS LiasonCommented:
Can you first take a step back and explan exactly what you have here?
Perhaps there is an alternative solution or design.

For example, if your concern is returning to "the record" (After a Requery) , then this is simple to do:

' Return to the record

'Declare the variables
Dim rs As Object
Dim lngID As Long
    'set (save) the ID field to the ID of the current record
    lngID = Me.ID
    Set rs = Me.Recordset.Clone
   
    'Requery
    Me.Requery
   
    'Move back to the record
    rs.FindFirst "[ID] = " & Str(Nz(lngID, 0))
    If Not rs.EOF Then Me.Bookmark = rs.Bookmark


JeffCoachman

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
The 7 Worst Nightmares of a Sysadmin

Fear not! To defend your business’ IT systems we’re going to shine a light on the seven most sinister terrors that haunt sysadmins. That way you can be sure there’s nothing in your stack waiting to go bump in the night.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Are these calculated values ... in the text box(s) ?

=<SomeExpression>

?

mx
0
ahashashAuthor Commented:
Thanks
0
Jeffrey CoachmanMIS LiasonCommented:
ok
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Programming Languages-Other

From novice to tech pro — start learning today.