Refreshing 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

(Sorry for double posting, I put this in the wrong place initially.)
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Refreshins data 1
Access Form Refresh 1
Need combo box to refresh when moving to new record 2017 1
Refreshing a query 1
Form_Delete event can't fire requery in other form 1
Copy form datasheet to table 4
Subforms won't refresh after new record 3
Requery single record in datasheet view 9

Back
Top