Sub Form Auto Save Disable && || clear subform field values

[carlchapman]

Hi,

I have a subform within a form. The subform only displays depending on a value in a field (combo box).

Private Sub chsAct_AfterUpdate()
If (Me.chsAct = "Appointment") Then
frmAddApp.Visible = True
Else
frmAddApp.Visible = False
End If
End Sub

This works fine, except, If i go back to the combo box and change the value, if i typed anything in the subform, it is automaticaly saved. This is no good because it may not need saving.

When you come back to the sub form from the field list, the data is still in those fields. That is very nice, and that is beneficial. Their must be a way to disable auto save, and "field required" etc until i save the record, and IF value at point of onClick is false to be that particular subform, and subform has records/data, Clear those subforms and only enter data that is required in selected subform and parent form, but do not clear the custom queries for each sub form until save point,, this would ensure that if i come bk to a subform all ready filled, it will still be filled

Any help?