Refresh using VBA 1

[PL01]

I need to activate the "refresh" function from the "records" pulldown menu inside my VBA code but nothing seems to do the trick. If I don't use the pull down menu a pop up window gives the following error -

"The Data has been change. Another user edited this record and saved the changes before you attempted to save your changes. Re-edit the record.

 

[PHV]

Does really another user edit the record at the same time ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[TheAceMan1]

How are ya PL01 . . .

Have you tried:

[blue]   Me.Refresh[/blue]

[blue]Your Thoughts?[/blue]

BTW: Welcome to [blue]Tek-Tips![/blue] Do go over one of the links at the bottom of my post. The links critique how to ask questions and get quicker/better answres, as well as providing insight into etiquette here in the forums. . . .

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[PL01]

Thank you. of course. The simplest things are the most difficult. I was using me.requery which didn't work, but what is the diff?.

 

[TheAceMan1]

PL01 . . .

In VBA, put the [blue]cursor[/blue] within the word [blue]Refresh[/blue] and hit F1 . . . Its called [blue]context sensitive help[/blue].

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[PL01]

It doesn't seem to work with text on the tool bar at the top of the screen. But, thanks.

 

[TheAceMan1]

PL01 . . .

I stated: in [blue]VBA![/blue]

In any code window type [blue]Refresh[/blue] set the cursor and try again! . . .

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886