txtboxes on a form

[Junior]

my form has txt boxes that display name, tiltle, etc. from a query data
source. the form uses a cbobox to select the employee name and recordset
clone in afterupdate to display the info.\

however, the textboxes retain the info from the last record
when the form opens..
how can i make the txtboxes blank when the form opens?

 

[TPratt]

in the form's "On Open" or "On Load" event:

Private Sub Form_Load()

TextBox1Name.Value = Null
TextBox2Name.Value = Null and so on...

End Sub

 

[Junior]

thanks T

in the form's "On Open" or "On Load" event:

Private Sub Form_Load()

TextBox1Name.Value = Null
TextBox2Name.Value = Null and so on...

End Sub

 

[Junior]

T- your suggestion din't work-
i tried setting the values on load and get a 'recordset is not updateable'
error message
also tried onclose
then tried
Me!txtName=Null and Me!txtName=""
with error 'you can't assign a value to this object'
The txtboxes are enabled 'Yes' , Locked - "No'
however, the Query is not updateable..

 

[TPratt]

Your text boxes must be bound. I, for some reason, was under the assumption
that they were unbound.