hi
I have a form called "frm_LevelExportCIN" - in this form, there are six command buttons:
Select All CIN Fees
Delete All CIN Fees
Select Product A fees
Select Product B fees
Export
Close
When I used the VBA to select the fees under each button, it was moving through each record and then check the ones "specified" in the VBA codes. I ended up using the "update query" which means which user click on Select All CIN Fees button, the update query check off all record fields called "export". When user click on "select product a fees", the update query only update the ones specified under the update query criteria. The purpose of this command is so that my Export button will only export the ones checked.
So far it is working fine, but I am just not sure if this is the best way to achieve these types of selections. Any recommendations?
Thank you!