"Eric" <eh******@gmail.comwrote in message
news:11*********************@i3g2000cwc.googlegrou ps.com...
Is it possible to create an unbound variable in a continous form and
linked with another table variable. If yes then how to declare that
variable and how to point another table variable.
I'm not certain what you are asking, Eric.
VBA code is where you define and use _variables_. Forms have Controls, and
in some Controls (Text Box, Combo Box, Check Box, etc.) you display and can
edit Fields from the Table, Query, or SQL Statement that is the Record
Source of the Form.
Easiest way to display information from two Tables in one Form is to join
those Tables in a Query that you use as the Form's RecordSource.
If you want to display information from another source than the
RecordSource, you could...
* use a multi-column Combo or List Box, of which
the other source is the RowSource
* use a DLookup as the Control Source (caution: the
Control will not be updateable)
* set it from code (caution: if the Control is actuall
unbound, whatever you set in the current Row will
also be displayed in every other row on a Continuous
Forms view)
If this isn't enough help to answer your question, please clarify and
perhaps someone can assist.
Larry Linson
Microsoft Access MVP