Getting txt from cbo field 1

[BabyPowder2u]

I have a cbo field cboRoomType it has 2 columns, an index & txt
I want to display the text from that field in a txt box.

I know this is simple, but I'm getting the syntax wrong. The following gives an error (in effect it is looking for the value (as a variable)in cboRoomType instead of taking the value & transferring it)
I have:
txtChnlType = Me(cboRoomType.Column(1))

any Help would be appreciated.

T

 

[PHV]

And this ?
txtChnlType = Me!cboRoomType.Column(1)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[BabyPowder2u]

Yep, That works a whole lot better.

Thanks, PHV