Updating Feilds using AfterUpdate

[input1000]

Trying to write the code for this:

This a punchlist form(fills data in tblpunchlist)
I have a feild that you manually enter the craft. After updating the craft (this is based tblcraft) I want a feild to autofill the responsible superintendant.

Private Sub ComboRespCraft_AfterUpdate()

Me.CboRespSuper = [tblCraft].[ResponsibleSuper]

End Sub

This is what I tried, but i dont think I'm coming at it write.

 

[TheAceMan1]

How are ya input1000 . . .

If [blue]ResponsibleSuper[/blue] is included in [blue]ComboRespCraft[/blue], then it could be as simple as:

[blue]   Me.ResponsibleSuper = Me.CboRespSuper.Column([purple][b]?[/b][/purple])[/blue]

Note: column indes starts at zero.

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[input1000]

Thanks, I just added the second column onto the query for the combo box. And used that to grab the info! Works great!

Thankyou so much!