Multiple checkbox selections

[Linda]

I created a temp table bound to a form in datasheet view. The idea
was to create a way for users to select the one item from the Left
column and multiple items on column 2.

Column A Column B
Fruit Apples
Meats Oranges
Carbs Steak
Potato
Chicken
Bread

When I create a checkbox for Column A and Column B, when one is
selected, all becomes selected. 2 Issues; one is there a way to not
use temp table, two how to deal with the checkbox in a datasheet form?

 

[Mark A. Sam]

Linda,

If you want to make individual selections from record to record, the
checkbox needs to be bound to a table. I don't understand the second part
of your question about how to deal with a checkbox in datasheet view.

God Bless,

Mark A. Sam

 

[Linda]

But selections will be just temporarily checked off and then erased
for the next set of selections. My 2nd part question; when you create
a datasheet and have an unbound checkbox field, in form view what
happens is when you select the checkbox, and say you have data already
in there, the entire list of checkboxes also becomes selected.

 

[Mark A. Sam]

But selections will be just temporarily checked off and then erased
for the next set of selections.

It seems as though someone else created the application. Know knowing the
purpose or process and not knowing the programmers intent, I can't answer
this. I think it may be beyond the scope of this forum.

My 2nd part question; when you create

a datasheet and have an unbound checkbox field, in form view what
happens is when you select the checkbox, and say you have data already
in there, the entire list of checkboxes also becomes selected.

That is becuase the checkbox needs to be bound to a table field to display
seperate selections for each record. This could be the reason for the temp
table. I don't know if it makes sens to you.

 

[Linda]

Ok, let me make it simpler. I created an datasheet form which is
bound to a temp table because I need to create groups which merges
information between 2 columns:

Column A Column B
Fruit > > Apples
Meats > > Oranges
Carbs > > Steak

Potato
Chicken
Bread

This is a simplistic example. I would like the user to select Fruit
and match with Apples and Oranges and when they click "save" a
grouping is created in an entirely separate table. Imagine there are
checkboxes next to each item for both Columns A and B (I just don't
know how to display in this message. I will use ">" to represent
checkbox).

Really my question then is there a better way to do this without me
using temp table to display Columns A and B?

 

[Mark A. Sam]

Sorry Linda, I'm still lost. I can't visualize your application. It sounds
like you need an unbound form in Form View, with checkboxes, rather than a
datasheet. Then if you selected fruit, in the AfterUpdate event of that
checkbox, you would set the value of the fruits checkboxes to true. Not
understanding your purpose, I can't explain the saving to table part.

 

[John W. Vinson]

how do i create a unbound checkboxes within datasheet

Since a) the checked values won't be stored and b) you can't use them in code
if it's a table (rather than a form), why would you WANT to? What are you
trying to accomplish?