Autofill another field in the form

[Frank Situmorang]

Hello,

My officersname of our church is filled by combobox based on a member query.
The coilumn count in this combox are 3 cosist of full name, last name and
memberID.
I want the memberID will be automatically filled in anther field of the same
table ( name of the field is OfficersID(in Indnonesian) . I have tried to put
in afterupdate of the officersname:
Private Sub NamaPel_AfterUpdate()
' Update No_URTAngt controls based on value selected in NamaPel combo box.
Me!NO_URTANGGOTA = Me![NamaPel].Column(3)
End Sub

but it wont work.

Could you please help us

With many thanks

 

[Dale Fye]

The combo boxes columns are zero based, so if you have 3 columns, they are
numbered 0, 1, 2.

HTH
Dale