alanponeill
New Member
- Joined
- Oct 6, 2004
- Messages
- 22
I have a form that is using a table as a data source.
I want to be able to filter the form based on various criteria (using the buttons on the toolber) and then at some point be able to set the value of a Y/N field on each data record included in the filtered list to -1.
I have created on action button with code which will be executed on Double Click of the mouse and reckon that I should define a record set as the filtered form list but do not know how to set the filtered form data source as the recordset source.
I cannot use a query as the users will not know what filters they wish to perform at the start of the process.
Am I going about it the best way or is there a better way? If so, how do I proceed? If not, what should I do instead?
I want to be able to filter the form based on various criteria (using the buttons on the toolber) and then at some point be able to set the value of a Y/N field on each data record included in the filtered list to -1.
I have created on action button with code which will be executed on Double Click of the mouse and reckon that I should define a record set as the filtered form list but do not know how to set the filtered form data source as the recordset source.
I cannot use a query as the users will not know what filters they wish to perform at the start of the process.
Am I going about it the best way or is there a better way? If so, how do I proceed? If not, what should I do instead?
