|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 5th, 2006, 06:34 PM
posted to microsoft.public.access.forms
|
|||
|
|||
Display data from another table in unbound textbox.
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 
|
|
#2
October 5th, 2006, 07:56 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Display data from another table in unbound textbox.
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" wrote: 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
|
|
#3
October 5th, 2006, 10:12 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Display data from another table in unbound textbox.
Klatuu,
Thank you it works great "Klatuu" wrote: 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" wrote: 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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
