Hi all,
First off, I apologize for asking the what I assume to be one millionth variation of this question.
I am very perplexed right now, as to what I am doing wrong! Previously, I have typed in =[var_name].[column](1) into an unbound textbox which will then show the second column of the combobox of the variable specified. This has worked perfectly in a few different reports (and forms) I have created in the past. However, I am not having luck doing so with a new report I've created. I am even using some of the same variables (that still work) in previous reports. I've tried copying and pasting the same code, which doesn't work. The error I receive, of course, is "#Name?". The only thing that is different is that I've recently switched to a SQL backend. I don't think that has anything to do with it, but I can't think of anything else!
Does anyone have any ideas about what I'm doing wrong, or suggestions to circumvent this issue?
Any help is much appreciated!!
Thanks!
First off, I apologize for asking the what I assume to be one millionth variation of this question.
I am very perplexed right now, as to what I am doing wrong! Previously, I have typed in =[var_name].[column](1) into an unbound textbox which will then show the second column of the combobox of the variable specified. This has worked perfectly in a few different reports (and forms) I have created in the past. However, I am not having luck doing so with a new report I've created. I am even using some of the same variables (that still work) in previous reports. I've tried copying and pasting the same code, which doesn't work. The error I receive, of course, is "#Name?". The only thing that is different is that I've recently switched to a SQL backend. I don't think that has anything to do with it, but I can't think of anything else!
Does anyone have any ideas about what I'm doing wrong, or suggestions to circumvent this issue?
Any help is much appreciated!!
Thanks!
