Runtime Error '2448'

[Momof2]

I have a subform based from a "Coding" table with a combo box (Charge
Description) in which lists Charge Descriptions and Charge Codes based from
"charge code" table. When the charge description is chosen I have the control
source on the Charge Code text box to automatically populate with the
following code: =[charge description].[column](1). which works fine however
it does not save the charge code to the "coding" table.

I tried running the following code:
Private Sub Charge_Description_AfterUpdate()
Me.Charge_Code.Value = Me.Charge_Description.Column(1)
End Sub

now I'm getting a runtime error '2448'. So now i'm stuck any ideas to fix
this?

 

[Golfinray]

Forms and subforms are usually run from ONE table or query. The mainform is
the one side of a one - to - many relationship and the subform is the many
side. It sounds like you are trying to make one mainform - subform run from
two different tables. You probably should try to rearrange your structure or
go to something like tabbed forms.