The easiest way would be to simply copy this query and create a second query that omits the update to str_commentsNotes. Then in the button click event (assuming your using the command button from previous threads) you would have vba like
Code:
If IsNull(Me!str_commentsNotes) Or Me!str_commentsNotes = "" Then
'call query with update to str_commentsNotes here:
Else
'call query without update to str_commentsNotes here:
End if
Again this is based on what you already have and specifically asked for in that *other* thread. But you don't really need to call an update query at all. Instead you could do
Code:
Dim truckNumber as Variant
Dim userComments As Variant
truckNumber = InputBox("Truck Number?")
'do some input validation here
If IsNull( Me!str_commentsNotes ) Or Me!str_commentsNotes = "" Then
userComments = InputBox("Enter Comments/Notes:")
'possible do some input validation here too
End If
'Update the fields in the current row of the form's recordset:
Me!str_truckNumber = truckNumber
Me!str_commentsNotes = userComments
Me!bool_isComplete = True
Me!dtm_completedTimeStamp = Now()
'Explicitly save the changes to the record
Me.Dirty = False