Multiple selection (even no in succession) and insert in another t

N

Nicola M

HI all! Access 2003.
Using "filter by form" I get my set of data. Then, after this, I need to
select some (maybe all) records and insert some data (usually the table IDs)
into another table(s). Using only Queries I'm able to do this but now I'm
trying to understand how get it using controls and VBA.
I'm thinking about adding a checkbox at the end of every record I get (in
continuous Form or Datasheets view) and also adding another checkbox (or a
button) to select or unselect all the records. After the selection I should
pass the selected ID to an insert (or update) query. That's all! Funny, no?
How can I approach this issue?

Thanks in advance for any suggestion and advice.
Nicola M
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create form with checkbox les that expand and collapse sections of the form? 0
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
QBF & Query Malfunction 0
Access 2010 DB not fuctional with multiple users 2
How do I clear a form? 0
Filter main form to records with no related records in subform,maintain updateable recordset 4
add mergefields to exsting word 2013 2

Top