Refreshing 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

(Sorry for double posting, I put this in the wrong place initially.)
 
W

Wayne Morgan

The only thing I can think of would be to set the form's Allow Deletions
property to No and have your own delete button on the form. Have the code in
this button set the field value and requery the form.
 
Top