After Update Event

[BartK]

I have a DB with TblInspector and TblViolation Data. Here is what I am having trouble with. On my form I have a combo box named Inspector and a text box named ARNumber. What I would like to have happen is anytime that I select John Doe from combo box Inspector it pulls his ARNumber from TblInspector and saves his ARNumber in TblViolation Data.

I have fields Inspector and ARNumber in my TblViolation Data. I am pretty sure it is an After Update Event. I just don't know what code to put where. This is what I currently have on my combo box. It pulls the number and displays it in the text box on the form but does not save it to the table. Any thoughts?

Private Sub Inspector_AfterUpdate()
Me.ARNumber = Me.Inspector.Column(1)
End Sub

 

[pr2-eugin]

The Form.. Which table is it bound to? It should be bound to the table you wish to update, the text box, should have its control source set to the Field in the table you wish to update.

 

[BartK]

Sorry forgot to say that. Form is bound to TblViolation Data and text box has it's control source set to ARNumber, Missed my control source. Works Beautifully now. Thanks