S smaumau Registered User. Local time Yesterday, 19:10 Joined Feb 23, 2006 Messages 32 Jul 13, 2006 #1 I have a form where sales can be entered. Whenever a [salesdate] is entered, I would like the [status] to automatically change to "Sold". How can I go about doing this?
I have a form where sales can be entered. Whenever a [salesdate] is entered, I would like the [status] to automatically change to "Sold". How can I go about doing this?
S Sergeant Someone's gotta do it Local time Yesterday, 22:10 Joined Jan 4, 2003 Messages 638 Jul 13, 2006 #2 Why do you need to store a value that can be derived whenever you need it? Iif(IsDate(salesdate), "Sold", "") If you must, use the AfterUpdate event of the salesdate text box... If IsDate(Me.txtsalesdate) Then Me.txtstatus = "Sold" End If
Why do you need to store a value that can be derived whenever you need it? Iif(IsDate(salesdate), "Sold", "") If you must, use the AfterUpdate event of the salesdate text box... If IsDate(Me.txtsalesdate) Then Me.txtstatus = "Sold" End If
