The user should be able to select records that will be processed by VBA based on ChceckBox value.
When I use Table as a source then there's no problem. I have field of Yes/No values, and I'm able to select each record inependently.
But when I want to use Query result as a source then it gets hard to get it working (probably it is not possible, but I need to confirm that).
I just need to populate Form with data of query result (AS Simple As Possible), to show data in a user friendly manner and be able to handle selected records with VBA script.
Example:
Let say that the user wants to do some operation on customers whose total order value is over some amount of money. Query result that is viewed in the Form and helps make decission is written bellow
Expand|Select|Wrap|Line Numbers
- select orders.cust_id, sum(orders.value), 0 as DoSomething
- from orders
- group by orders.id
Now I should be able in the form select those field that will be processed.
In VBA function I run across the Recordset of Form to obtain cust_id of selected orders and do with this value whatever I want to do.
I don't want to use "Select Into" in order to save results to table that will serve as source for what will be displayed in the Form.
Any comments will be apreciated.