Display data from another table in unbound textbox.

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

Guest

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
 
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
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Limiting Dropdown based on selection? 3
displaying leading zeros in unbound textbox 11
update subform from value in another form 2
VBA - retrieve data on last create named range from previous inserted named range 0
How to Populate Data from a table to another 0
Unbound textbox won't appear as currency 4
#Name? Textbox Problem in Access 2007 6
Multi select list box to unbound textbox 4

Back
Top