Refreshins data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using a form in DataSheet view and I am having trouble refreshing the
data after an udate.

I am coding in the Delete event and instead of actually deleting records I
am setting a 'Deleted' cloumn to 'Yes'. The query that the form's data is
based on has a WHERE that column is 'No'. That bit works fine.

I am having problem in ensuring the data viewed once this occurs is updated.
FORM.Requery will not work during a transaction and the Records Menu -
Refresh doesn't seem to do anything either.

Any help will be greatfully received.

Pedro
 
On the delete event, after you update the field to yes, did you run the code

Me.Requery
 
Back
Top