Ok (ps I hope i'm not helping in any school work...not allowed...don't worry :>)
So here it goes...roughly this is what i'll do:
1) first i create a new field within the table customers call it 'Report' and set it as data tpye Boolean and default as false
2) Then in VB create a form with a List box or combo as you wish, which will be populated with the customer's names and set the value as their unique ID (autonumber etc).
3) Teh user should select a user from teh combo box and using either drag and drop or double click or just a plain command button that says "Choose". This button's fucntion should run a query which will update that client's record "Report" field to true.
4) After he has chosen all the records the user will just run the report. Whitin the report there should be something like this: (in the datareports initialize event)
with RS 'Where Rs is of type recordset
.open "select * from Customers where Report = -1", connection (notice -1 stands for true)
set datareport1.datasource = rs
end with
5) There you go, the report should show all those who were selected. After that you have to refresh the whole table setting all the record's field Report to false!
Nick
