I have built an Assess database with various forms and in the process of expanding it to cover everything I need to do with it.
I'm at the point where before I proceed I need to be able to select a group of record.
There are about 30 fields in each record, some of which contain data from lookup table, another holds attached photos but the majority hold data from the table itself.
One from displays all the fields to allow data entry.
I can, by using the Filter option of ADVANCED, CLEAR ALL FILTERS then ADVANCED, FILTER BY FORM, than after entering one or more items of data in the form by typing in a data field - use drop the down box or click the radio button in the option group and clicking TOGGLE FILTER, have selected all the matching records.
This works perfectly for me but as there may/will be other users the ribbon etc. will be hidden preventing alterations to layout etc. I need a FIND MATCHING RECORDS button to switch from the menu to the search form then something to toggle records so all are selected (toggle filter) and another button to clear selected and start another search if required.
As the only bit of VBA I've managed to get to work is DoCmd.OpenForm "permissions", acNormal (found on internet lol) I don't hold out much hope of finding out how to do this myself.
Anyone help a COMPLETE BEGINNER?
I'm at the point where before I proceed I need to be able to select a group of record.
There are about 30 fields in each record, some of which contain data from lookup table, another holds attached photos but the majority hold data from the table itself.
One from displays all the fields to allow data entry.
I can, by using the Filter option of ADVANCED, CLEAR ALL FILTERS then ADVANCED, FILTER BY FORM, than after entering one or more items of data in the form by typing in a data field - use drop the down box or click the radio button in the option group and clicking TOGGLE FILTER, have selected all the matching records.
This works perfectly for me but as there may/will be other users the ribbon etc. will be hidden preventing alterations to layout etc. I need a FIND MATCHING RECORDS button to switch from the menu to the search form then something to toggle records so all are selected (toggle filter) and another button to clear selected and start another search if required.
As the only bit of VBA I've managed to get to work is DoCmd.OpenForm "permissions", acNormal (found on internet lol) I don't hold out much hope of finding out how to do this myself.
Anyone help a COMPLETE BEGINNER?