tag records

[airpix]

Is it possible to select (tag) certain records (say 20 or more) and show those records in their own table?

 

[Trendsetter]

If you "Tag" or identify the records by adding something to the record say a Yes/no field marked "yes", then you can group these records via a query and then convert those records to a table using the "Make Table" type of query.

Is this what you want????

 

[airpix]

Each of my records is for an invoice with a seperate invoice number. When multiple invoices are paid I would like to be able to select those particular invoices and bring only those invoices / records to a table so that I can mark them paid in the "paid" column I have created. Thanks

 

[Trendsetter]

I would be tempted to have a multi-select listbox with all unpaid invoices showing sorted by Customer & then Invoice No.
That group all of one clients invoices together and you can go down that list and select the invoices being paid.

Then...
Use the ItemSelected() from the listbox to do the work you want - if you have a field in the table that you want ticking then do by code..

Do you need help with this code??
Is this method OK for you??