NeoZakz
Registered User.
- Local time
- Today, 10:03
- Joined
- Jul 22, 2002
- Messages
- 12
I have the following code in VB:
Private Sub days_after_AfterUpdate()
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].Value = DateAdd("d", Me![Seq], Me![Date Due].Value)
End If
End Sub
In the Dlookup part the Me![Combo119] wants a specific item from the combo box. Im trying to get it to read whats there currently and use that as the base to get the rest. Is there a way to make the Combo box see whats inside it and use it to do the rest of the lookup?
Thanks for any help in advance.
Private Sub days_after_AfterUpdate()
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].Value = DateAdd("d", Me![Seq], Me![Date Due].Value)
End If
End Sub
In the Dlookup part the Me![Combo119] wants a specific item from the combo box. Im trying to get it to read whats there currently and use that as the base to get the rest. Is there a way to make the Combo box see whats inside it and use it to do the rest of the lookup?
Thanks for any help in advance.
Last edited: