Simple Combo Box Question

[fabby1]

Hi

I have a combo box chat has two columns Firstname and surname

How can I assign the Firstname to one global variable and the Surname to another global variable

I can do it on the Firstname as this is the first column

G_Forname = Me.cboUser.Value

How can I select the second column

thanks

Phil

 

[Mute101]

Ello,

I think that;

G_Surname = Me.cboUser.Column(1)

should do the trick for you.

Hope that helps
Simon

----------------------------------------
My doctor says that I have a malformed public duty gland and a natural deficiency in moral fibre and that I'm therefore excused from saving universes.
----------------------------------------

 

[fabby1]

Thanks

Works Great Simple when you know how