afterupdate data disappears from form

[slimjen]

All I am using ver 2010. I have a form based on a table. To add new records; I use a combo box so the users can choose the cust_id. The combo box has the cust_id, custname and accessid. I want after the cust_id is choosen from the combo box to autopopulate the fields in the table cust_id, custname and assessed. It does this but disappears from the form but when I go to the table; it's there. When I go back to the form; it's also there after the record loses focus and return to that record. Users need to complete the form before the record loses focus. What am I doing wrong? I've done this task before without incident. The only difference is I took over this database but I created the form. The following is the code I'm using:

Private Sub cboClientID_AfterUpdate()
Me.Client_No.Value = Me.cboClientID.Column(0)
Me.Client_Name.Value = Me.cboClientID.Column(2)
End Sub

Can you tell me what I'm doing wrong? I know it's something simple.

[ranman256]

are all these boxes bound to a field? If not, they will disappear.

[slimjen]

All boxes on form are bound except the cbo. It appears after I move off the record and come back and it's appends to the table right away. weird.

[slimjen]

Still need assistance. I have test my form and realize that if I select from the dropdown; it auto populates like I need. but if I type in the combo box; it doesn't. Why is this and what do I change? Please help