Refresh TextBoxes

  • Thread starter Thread starter an
  • Start date Start date
A

an

Hello!

I have a command bouton do delete records.
After deleted appear the message #Deleted in all text
boxes.
How is possible to refresh data to see next record data?
Thanks in advance.
an
 
Hi,


Me.Refresh should do, unless you are on a deleted record, visually.
You can try Me.Requery, but there are side effects, such as putting you back
at the beginning of the (new) recordset of records to be displayed.


Hoping it may help,
Vanderghast, Access MVP
 
Hi,

You could look at using a .Requery, this will then requery the source of
the data. The only issue, with this, it will bring you back to the start of
the records. So if you are on record 100, when you requery, your back at
one. One way round this, is to remember the record number you were on,
store the value, requery the records and then find the record you where on.

I hope this helps

Mark

This information is provided "As is", and expresses no warranties and
confers no rights.
 
Back
Top