I've a set of tables/form/macro/queries setup in access, although it fundamentally works, I'd like a better solution to how the form pulls data from the tables.
Basically I have tables which consist of a whole bunch of entries and I want to generate a new table which pulls all the data from the original table (but doesn't pull those rows I don't need). At the moment this works by the first column having a unique entry, and the form/query pulls the information from 20 drop-down boxes on the form which generates the new table from those drop-downs. I'd like to get rid of the drop-downs, and either have tick-boxes or a CTRL+Select from a long list.
The form is using the following Query Criteria: [Forms]![QBF_Form]![Vessel] Or [Forms]![QBF_Form]![Vessel2] Or [Forms]![QBF_Form]![Vessel3] Or [Forms]![QBF_Form]![Vessel4] Or [Forms]![QBF_Form]![Vessel5] Or [Forms]![QBF_Form]![Vessel6] (etc)
Any thoughts?