Form Anomaly

  • Thread starter Thread starter yann47
  • Start date Start date
Y

yann47

Hello!
I have a built a form with a Tab control. I have expanded the Tab
Control to catch all the form. Now I am trying to put some values in
some text boxes in the form. However when I press the Control Source
and go to Expression Builder I click on the table, then the field e.g.
Author and then click on the Value. When I switch from the Design view
to the Form View of the form I don't get the correct value in the text
box but this: #Name?

Any help much appreciated
Thanks
Yann
 
yann47 said:
Hello!
I have a built a form with a Tab control. I have expanded the Tab
Control to catch all the form. Now I am trying to put some values in
some text boxes in the form. However when I press the Control Source
and go to Expression Builder I click on the table, then the field e.g.
Author and then click on the Value. When I switch from the Design view
to the Form View of the form I don't get the correct value in the text
box but this: #Name?
Click to expand...

[TableName]![FieldName]

....is not a valid expression for a control. You either bind the form to
the table and then use just the field name as your ControlSource or you use
a DLookup() function if you want to retrieve a value from a different
table.

(What does this question have to do with your TabControl?)
 
I am just a beginner and I thought it had to do something with the Tab Control
Cheers
Yann

Rick Brandt said:
yann47 said:
Hello!
I have a built a form with a Tab control. I have expanded the Tab
Control to catch all the form. Now I am trying to put some values in
some text boxes in the form. However when I press the Control Source
and go to Expression Builder I click on the table, then the field e.g.
Author and then click on the Value. When I switch from the Design view
to the Form View of the form I don't get the correct value in the text
box but this: #Name?
Click to expand...

[TableName]![FieldName]

...is not a valid expression for a control. You either bind the form to
the table and then use just the field name as your ControlSource or you use
a DLookup() function if you want to retrieve a value from a different
table.

(What does this question have to do with your TabControl?)
Click to expand...
 
Back
Top