How do I get the VB to read whats in the combo box with out making it an = "blank"?
Heres what Im using:
If IsNull(Me![Combo119]) Then
Me![Date Due] = DateAdd("d", Me![Seq], Me![Date Due])
Else
DLookup("[Miledate]", "Mile1", Me![Date Due] = Me!
[Combo119]) = Me![Date Due] = DateAdd("d", Me![Seq], Me!
[Date Due])
End If
The problem is in the Me![Date Due] = Me![Combo119]
The Me![Combo119] wants it to be Me![Combo119] = "PPR1"
Is there a way to get it to read whats in the combo box it self?
Heres what Im using:
If IsNull(Me![Combo119]) Then
Me![Date Due] = DateAdd("d", Me![Seq], Me![Date Due])
Else
DLookup("[Miledate]", "Mile1", Me![Date Due] = Me!
[Combo119]) = Me![Date Due] = DateAdd("d", Me![Seq], Me!
[Date Due])
End If
The problem is in the Me![Date Due] = Me![Combo119]
The Me![Combo119] wants it to be Me![Combo119] = "PPR1"
Is there a way to get it to read whats in the combo box it self?