conditional statement for field in form

[rciiipo]

I am new to access.

I have a form titled "form1" with a textfield titled "code." If the textfield "code" is left blank in the form by the person submitting the form and they click submit, then I want to check the field "code" to see if it is blank (empty), and if it is, input into the table "clients" under column "client_code" the value "tem." If the field is not blank, then I would like to use whatever the user input into the field. All other fields in the form would be irrelevant as to whether they have values or not, they will be submitted as is.

Can anyone set me up in the right direction for this? Or provide me with an example?

Thanks
Richard

[JKing]

I'm assuming the form is bound and that the control source for the textbox code is client_code. Use the before update event to check if the textbox is null if so set the textbox equal to "tem"

Private Sub Form_BeforeUpdate()
If IsNull(Me.code) Then
Me.code = "tem"
End If
End Sub
 

[rciiipo]

I'm assuming the form is bound and that the control source for the textbox code is client_code. Use the before update event to check if the textbox is null if so set the textbox equal to "tem"

Private Sub Form_BeforeUpdate()
If IsNull(Me.code) Then
Me.code = "tem"
End If
End Sub
 

Thanks a lot. It works!

Richard