469,578 Members | 1,263 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,578 developers. It's quick & easy.

Is it possible

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.

Thanks,

Aug 16 '06 #1
1 1178

"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

Aug 21 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Julia Briggs | last post: by
36 posts views Thread by rbt | last post: by
1 post views Thread by AAA | last post: by
25 posts views Thread by Piotr Nowak | last post: by
14 posts views Thread by bjorklund.emil | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.