duplicate a control on a continuous form

  • Thread starter Thread starter Ayelet
  • Start date Start date
A

Ayelet

Hi,
this is a problem i have encountered several times, and
still haven't been able to work it out.
I'm trying to build a continuous form, which will contain
some data (like a product's list), and add to each line a
check box, something like "buy me!", so that the user can
check the items he/she wants and then produce an order for
all the wanted products at once.
The problem is that, while i can very easyly enter the
checkbox, there is only One check box - so when one is
checked, all the "others" are checked as well, same when
it is cleared, so this is no good for me.
a solution i thought of is using a button which has to be
pressed over and over again, but this is confusing and
could mean trouble, not to mention annoying, for the user.
i even considererd adding a field to the actual table, so
that i will have a place in the DB for this "buy me" flag
and so it can automatically be a field in the form, but
that would be inefficient, unclear for programming and
extremely wrong design-wise.
So if anyone has any idia how i can do this, Please help!
10x,
Ayelet
 
You must provide a field to write the value to if you want the check box to
be different on every line.

There still seems to be something wrong here though. Normally you would
allow the user to add the products they wanted to buy to an order, along the
lines of the Orders form in the Northwind sample database. The user is not
modifying a check box in the Product table; they are appending records to
the Order Details table.
 
Back
Top