Control Source

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Please bear with me I am new to Access
I currently have a expression in the Control Source
=[Forms]![frmPersExperience]![Combo2] were Combo2 is from a combobox. I keep
getting error msg. on report #Name and also I want to place an "X" in another
field and need to know proper expression for this. Thank You a head of
time......
 
Amour,

The #Name is usually caused by a spelling error or incorrect syntax in
an expression. Are you sure that frmPersExperience is the exact correct
spelling for the name of the form? And it's an actual form, not a
subform? And that Combo2 is the exact correct spelling for the name of
the combobox? And the form is open at the time the report is printed?

As regards the "X", do you mean you want an X to be shown in an unbound
textbox? You could set a Control Source like this...
="X"
But why not just put a label on the report, with X in its caption?
 
You see my expression, is there a syntax error in it? This expression is for
a text field that comes directly from a combobox. What do you mean about
keeping the combobox open when I try this the same thing occurs. I am stuck,
I have been trying to resolve for over two weeks now. I have checked the
spelling and even brought this expression in with the help of the expression
builder so there is no way that it can be misspelled. Please can someone help

Steve Schapel said:
Amour,

The #Name is usually caused by a spelling error or incorrect syntax in
an expression. Are you sure that frmPersExperience is the exact correct
spelling for the name of the form? And it's an actual form, not a
subform? And that Combo2 is the exact correct spelling for the name of
the combobox? And the form is open at the time the report is printed?

As regards the "X", do you mean you want an X to be shown in an unbound
textbox? You could set a Control Source like this...
="X"
But why not just put a label on the report, with X in its caption?

--
Steve Schapel, Microsoft Access MVP

Please bear with me I am new to Access
I currently have a expression in the Control Source
=[Forms]![frmPersExperience]![Combo2] were Combo2 is from a combobox. I keep
getting error msg. on report #Name and also I want to place an "X" in another
field and need to know proper expression for this. Thank You a head of
time......
Click to expand...
Click to expand...
 
Please bear with me I am new to Access. Expression is spelled correctly and
there doesn't seem to be any syntax errors in the expression. This
expression is text related and should be simple to resolve. Please can
anyone help!!! Thank You!!
 
Problem was solved. I was using a bound text box when I should have been
using a Unbound text box
 
Back
Top