By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,871 Members | 2,304 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,871 IT Pros & Developers. It's quick & easy.

Is it possible

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a

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