I am trying to build a form which be able to develop and save select queries for future use. also allow a customization of these select statements. the best way I can explain this is to use a hypothetical case.
If I had a database of 80 customers and I wanted to be able to pick and choose specific customers to send infomation to, but instead of recreating the select case every time I wanted to save it into a query. Is there a way to create a form using something like a check box that would allow me to select customers and then save that list for reuse.
I just dont know where to start.
thanks guys
Cory

Yes. You could have a main form bound to a table like

tblSelectcases
id
selectcaseno
name1

and a datasheet subform on that bound to

tblSelectcasesdetails
id
selectcasesid (foreign key to tblSelectcases)
customerid (foreign key to tblCustomers)

User can put in as many customers as he wants. For your report join the tblMaintable.customerid to tblSelectcasesdetails.customerid, join tblSelectcases to tblSelectcasesdetails and select on selectcaseno. No customerid in tblSelectcasesdetails, no customer on the report.

It's possible you don't really need this. Can you give an example?

Robert

The actual usage of this is for an environmental chemistry database. I have an analysis with which I analyze for 80 volatile organic compounds (VOC's) every time. I always want to retain all the data from each analysis but often my customers provide a specific list of Chemicals which are the only compounds they want to see on their report. Different projects from the same client may require different lists as well as client to client differences. Very often i would be able to reuse these lists but I will need an easy way to customize the so i can add and subtract
as a very short example
total list includes 5 chemicals
Acetone, Benzene, Toluene, Xylene, Ethanol

Client 1 might only want to see Benzene, Toluene, Xylene for one project but see all of them for another project. If you have a better idea on how to accomplish this I am all ears. I am not an extremely good Access developer, I think I have the patience and stubborness to try and figure it out
thanks for the Help Robert

I appreciate all of your advice
Cory

Jerry Dennison has an example in the Code Archive, here, that does exactly what you want. There are others there as well. Using the Advanced Search and 'multi select' for the criteria on the Code Archive should get you plenty of options.

To save it, you will need to use tables. Chemical id will also have to be added to the table.

Robert,
can you look over my relationships view and confirm I am doing this correctly

Cory

Yes, it looks good.

I am making alot of headway but I am out of time for today, thanks for the help, and look for some followups tomorrow

Okay.