combo box column to become control source of unbound textbox

[Mr_Si]

Hi there,

I have an unbound textbox which I want to use to show a value from a combo box, just for reference like.

I have the following expression in this textbox but in form view, it's showing #Name? rather than being blank...

=nz([lngzAddress].[column(1)],0)

I've tried it without the equals sign and that just gives an error.

I've tried with putting a [me]. in front of the [lngzAddress] but that doesn't work.

Is there something I'm typing in wrongly?

 

[Scaniafan]

If the textbox is on the same form as the combobox, just =[ComboName].Column(1) should do the trick, where 1 is the number of column you want to appear in the textbox. Note that column count in Access starts at 0.

 

[Mr_Si]

Yep that worked. Simpler than I was expecting!

I Didn't realise I didn't need the nz function in the expression

Thanks

 

[Scaniafan]

Yep that worked. Simpler than I was expecting!

I Didn't realise I didn't need the nz function in the expression

Thanks

No problem. Didn't know that a Access-Noob could assist someone on this forum I mean, I don't even know of the existing of the nz-function