E
Evan McCutchen
Hello, i received a response from Dirk Goldstar about having multiple check
boxes relating to one form (I've included the text of both of our messages
below). Could someone please explain to me what a linking table is and how i
would go about using one? or at least point me in the direction of a good
tutorial?
Thanks,
Evan M
evan AT radiologyonesource DOT com
=---------------------------------------------=
Hello,
On my companies form, I have a subform that contains ~30 checkboxes that
relate to what that company does. Is there a way that i can get each check
box to store a value other than -1, 0, or 1? I want to store the company's
ID number in place of either the -1, 0, or 1. Any help would be greatly
appreciated!
Thanks!
Evan M.
evan AT NOradiologySPAMonesource DOT com
RESPONSE:
Controls (such as check boxes) don't store values, they only present
them to the user. But a check box cannot represent any value other than
0, -1, or Null (and Null is only available if the check box is unbound
or bound to a numeric field, and its TripleState property is set to
True).
If what you have in mind is for the subform to present a list of items
with check boxes beside them -- one item and check box to a record --
and check off items to indicate that the current company is associated
with them, then it is possible with some rather elaborate code to make
this work. It might be easier to use a multiselect list box, and (using
code again) select/deselect items in the list box as you move from
company to company, by querying the table where the linking information
is stored. Naturally, the user's clicking on any item in the list box
would be used to update the linking table.
--
Dirk Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup)
------------------------------------------------------------------
boxes relating to one form (I've included the text of both of our messages
below). Could someone please explain to me what a linking table is and how i
would go about using one? or at least point me in the direction of a good
tutorial?
Thanks,
Evan M
evan AT radiologyonesource DOT com
=---------------------------------------------=
Hello,
On my companies form, I have a subform that contains ~30 checkboxes that
relate to what that company does. Is there a way that i can get each check
box to store a value other than -1, 0, or 1? I want to store the company's
ID number in place of either the -1, 0, or 1. Any help would be greatly
appreciated!
Thanks!
Evan M.
evan AT NOradiologySPAMonesource DOT com
RESPONSE:
Controls (such as check boxes) don't store values, they only present
them to the user. But a check box cannot represent any value other than
0, -1, or Null (and Null is only available if the check box is unbound
or bound to a numeric field, and its TripleState property is set to
True).
If what you have in mind is for the subform to present a list of items
with check boxes beside them -- one item and check box to a record --
and check off items to indicate that the current company is associated
with them, then it is possible with some rather elaborate code to make
this work. It might be easier to use a multiselect list box, and (using
code again) select/deselect items in the list box as you move from
company to company, by querying the table where the linking information
is stored. Naturally, the user's clicking on any item in the list box
would be used to update the linking table.
--
Dirk Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup)
------------------------------------------------------------------