how to update a record

[kronar30]

I have a form based on a query. It is Dynaset, continuous form. How do I update any user changes to the record before i run a delete query based on the delete key the user just set in the record?

 

[dhookom]

Can you provide more information? What are you attempting to do?

Duane
Hook'D on Access
MS Access MVP

 

[kronar30]

The Query the form is based on displays bid records with the included field delete-sw. On clicking the delete records button, a delete query is run to delete the records with the delete-sw set. All records delete except the last record the user just set the delete-sw (which still has the focus). Since I did not open and have control of the recordset in code, how do I force the last user record action to update the table before the delete query runs?

 

[PHV]

Add the following before launching the delete query:
Me.Dirty = False

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[kronar30]

Great, that worked. Thanks