Checkbox infront of every row in datasheet on form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Now this may be a very simple thing for most of you, but I am a newbie at VBA
so bear with me. I have this form that has one field of a query. Infront of
each row I want to have a single checkbox that I can select and then hit a
button and perform an action based on that single datarow. What I have been
getting is either a column of checkboxes next the column of the field, and if
I click one, they all click, or a single checkbox infront of the first row
and nothing else. Any suggestions?
 
Of course. If the "check" is not part of the record, how would Access know
which records were checked or which ones were not? To do this, you would
have to add a field to the table. In other words, you would have to include
the checkstatus of the record in the actual record in the table.

You would also wnat to build code that clears all the checks after you
perform whatever tasks you intend to perform.

For future reference, this is a pretty common question and you should search
before you post to a newsgroup. If you had searched, you would have found
over a hundred previous threads explaining this. Some of those may be much
more detailed than the response I just typed.

Google.com is a great place to review previous posts. Click the "groups"
option in google and type a string like the following....

microsoft.public.access check box checks all

or

microsoft.public.access unbound check box continuous form
 
Back
Top