Unbound Textbox Equals Listbox Column

guanfl

Registered User.
Local time
Today, 04:14
Joined
Mar 7, 2013
Messages
13
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.
 
Check that you have spelt the name of the list box correctly.
 
Definitely spelled correctly. Renamed the listbox just to be sure...recreated etc etc. I dont understand..I think my form is cursed..lol.
 
Perhaps the form is showing signs of corruption?
 
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)
 
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.
 
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.
 

Users who are viewing this thread

Back
Top Bottom