Hello, Please help
I have a List Box set Simple (I mean multi select). A Button nearby opens a Report which returns the List Box selected records – that works fine.
Next, I want an Option Group to perform a filter on Field1 of the selected Records.
What’s the best way to approach it?
Must I write my VBA in to each “Case Is” to create my Records filter I want, then a DoCmd.OpenReport to open a different Report which has the Field1 "Where" criteria done?
If so, I think I can do that.
Or can I simply have the Option Group "Case Is" part of the VBA tack something on the end of the my expression - something like;
“WHERE (((tblTable.Feild1)<1));”
Here's where I learned (copied) everything I know about List Boxes
http://www.baldyweb.com/multiselect.htm
http://www.access-programmers.co.uk/forums/showthread.php?t=136282
I have a List Box set Simple (I mean multi select). A Button nearby opens a Report which returns the List Box selected records – that works fine.
Next, I want an Option Group to perform a filter on Field1 of the selected Records.
What’s the best way to approach it?
Must I write my VBA in to each “Case Is” to create my Records filter I want, then a DoCmd.OpenReport to open a different Report which has the Field1 "Where" criteria done?
If so, I think I can do that.
Or can I simply have the Option Group "Case Is" part of the VBA tack something on the end of the my expression - something like;
“WHERE (((tblTable.Feild1)<1));”
Here's where I learned (copied) everything I know about List Boxes
http://www.baldyweb.com/multiselect.htm
http://www.access-programmers.co.uk/forums/showthread.php?t=136282
