Rich_Lovina
Registered User.
- Local time
- Tomorrow, 08:57
- Joined
- Feb 27, 2002
- Messages
- 224
I have a nice Add2Source Module, a la:
Private Sub Combo119_AfterUpdate()
If Not IsNull(Me.Combo119) Then
Me.Combo119.DefaultValue = "='" & Me.Combo119 & "'"
Else
Me.Combo119.TabStop = True
End If
End Sub
THIS CODE, applied to relevant fields, carries forward the data, except when that field has a need to be blank on the new record. Then the user uses backspace, but the previous 'default' holds.
How can I turn off that default operation if the target field must remain blank for the next nth records, but when data IS added, resume carry forward operation.
e.g. Do I say s'thing like
Elseif Null Me.Combo119 undo.
Sorry I just don't understand the use of all these codeswords.
Thanks in advance.
[This message has been edited by Rich_Lovina (edited 02-15-2002).]
Private Sub Combo119_AfterUpdate()
If Not IsNull(Me.Combo119) Then
Me.Combo119.DefaultValue = "='" & Me.Combo119 & "'"
Else
Me.Combo119.TabStop = True
End If
End Sub
THIS CODE, applied to relevant fields, carries forward the data, except when that field has a need to be blank on the new record. Then the user uses backspace, but the previous 'default' holds.
How can I turn off that default operation if the target field must remain blank for the next nth records, but when data IS added, resume carry forward operation.
e.g. Do I say s'thing like
Elseif Null Me.Combo119 undo.
Sorry I just don't understand the use of all these codeswords.
Thanks in advance.
[This message has been edited by Rich_Lovina (edited 02-15-2002).]
