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


--
H. Frank Situmorang

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

HTH
Dale
--
Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.



"Frank Situmorang" wrote:

> 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
>
>
> --
> H. Frank Situmorang