update a control based upon the conditional results of another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form where I need the LoadDate updated to the Now() date based upon
the LoadStatus equally Full Outbound. I have a similar situation where
another time stamp is updated based upon the LoadStatus selected and updates
my underlying table. It's the same as below; however, this one won't work
for me. Do you know what I am doing wrong here???

The code is as follows:

Private Sub cboLoadStatusID_Change()
If Me.cboLoadStatusId = "5" Then
Me.LoadDate = Now()

End Sub

Thanks!
 
If the LoadStatus field type is number, then lose the quote before and after
the five, that are used for string

If Me.cboLoadStatusId = 5 Then
Me.LoadDate = Now()
End If
 
Incredible! Thank you so much.

Ofer said:
If the LoadStatus field type is number, then lose the quote before and after
the five, that are used for string

If Me.cboLoadStatusId = 5 Then
Me.LoadDate = Now()
End If
Click to expand...
 
Back
Top