Display data from another table in unbound textbox.

R

Raj

I have a Form that I would like to display a Cycle number from a table that
is used only to hold this number. I don’t need to have this data in my main
table. I have tried adding [cycle]![txtcycle] in the ControlSource and the
Default Value but the Textbox displays #Name? is this possible to do this?
Thanks
 
K

Klatuu

Make the Control Source
=DLookup("[txtcycle]","cycle")

That assumes
txtcycle is the name of the field in the table
cycle is the name of the table
 
R

Raj

Klatuu,
Thank you it works great


Klatuu said:
Make the Control Source
=DLookup("[txtcycle]","cycle")

That assumes
txtcycle is the name of the field in the table
cycle is the name of the table

Raj said:
I have a Form that I would like to display a Cycle number from a table that
is used only to hold this number. I don’t need to have this data in my main
table. I have tried adding [cycle]![txtcycle] in the ControlSource and the
Default Value but the Textbox displays #Name? is this possible to do this?
Thanks
Click to expand...
Click to expand...
 
Top