Unbound Textbox Equals Listbox Column

[guanfl]

Hi, any reason why =listboxname.column(0) in the control source of a textbox will give me the value "#name?" ?

I've used it successfully on another form..but for some reason its not working for me.

 

[bob fitz]

Check that you have spelt the name of the list box correctly.

 

[guanfl]

Definitely spelled correctly. Renamed the listbox just to be sure...recreated etc etc. I dont understand..I think my form is cursed..lol.

 

[bob fitz]

Perhaps the form is showing signs of corruption?

 

[CJ_London]

what is the rowsource for your listbox? and is it producing a list?

If the bound column is set to 1 you could drop the reference to column(0)

 

[guanfl]

Rowsource of listbox is a query and is producing a list.. Yeap bound column 1 = column (0), tried moving the bound column and also column(x) accordingly.

 

[guanfl]

Perhaps the form is showing signs of corruption?

The form is a subform in a navigation control tab. Though i tried creating a test textbox on another tab with another listbox and it works.

I'll try recreate the form..i just don't see what the issue is.