G
Gsurfdude
In the forms property I set a record source to a query with the Record Type
property to Dynaset (Inconsistent Updates). This form contains about 50
controls (combination of Text boxes and Combo boxes).
I needed the Inconsistant updates so the user can edit the data - however,
I do not want the data that was updated in a particular control to be
commited to the
underlying table (Oracle linked tables) when moving to another record. When
ALL edits are done in a record
then the user will click a button that saves and performs other things. I
tried using this in the forms BeforeUpdate event:
Cancel = true
But it freezes and will not let me move to another record. I simply need to
be able to edit any of the 50+ data items without saving each one as it is
edited. Rather, edit whatever combination of fields and then save the whole
record.
I used this and it does work in the forms BeforeUpdate event:
If MsgBox("Changes have been made to this record." _
& vbCrLf & vbCrLf & "Do you want to save these changes?" _
, vbYesNo, "Changes Made...") = vbYes Then
DoCmd.Save
Else
DoCmd.RunCommand acCmdUndo
End If
however I do not want to have message boxes poping up on every item edited -
that'd be anoying to the user. Make sense?
Thank you.
property to Dynaset (Inconsistent Updates). This form contains about 50
controls (combination of Text boxes and Combo boxes).
I needed the Inconsistant updates so the user can edit the data - however,
I do not want the data that was updated in a particular control to be
commited to the
underlying table (Oracle linked tables) when moving to another record. When
ALL edits are done in a record
then the user will click a button that saves and performs other things. I
tried using this in the forms BeforeUpdate event:
Cancel = true
But it freezes and will not let me move to another record. I simply need to
be able to edit any of the 50+ data items without saving each one as it is
edited. Rather, edit whatever combination of fields and then save the whole
record.
I used this and it does work in the forms BeforeUpdate event:
If MsgBox("Changes have been made to this record." _
& vbCrLf & vbCrLf & "Do you want to save these changes?" _
, vbYesNo, "Changes Made...") = vbYes Then
DoCmd.Save
Else
DoCmd.RunCommand acCmdUndo
End If
however I do not want to have message boxes poping up on every item edited -
that'd be anoying to the user. Make sense?
Thank you.