If I enter a date in a certain field, I want a field on the form that is a combo box to automatically update to "Picked Up". How can I do this?
I guess I don't know the correct way to do this; I can't get it to work. I want the combo57 box to say "Picked Up" when there is a date in the Picked Up field...
'Check to see if a date is in the field
If IsNull(fldPickedUp) or fldPickedUp = "" Then
'there is nothing in the field
Else
cmbPickedUp = "Picked Up"
End if
End Sub
This should change the combo box value as you scroll through the records. On the Field after update put this code:
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.