Refreshins data

P

Pedro

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
 
O

Ofer

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

Me.Requery
 
Top