query launched form cbobox, saved with different names

[bluesage]

hi,

i want to create code for an afterupdate of a combobox which will create and save a query under a certain "name", but each time it is run, it is saved under another "name"

or the previous one is renamed, and the one being created stays the same.


lets say i have three choices, bob, frank, and susan.

is it possible to choose bob, and so the query that is created contains information related to bob but so that i can click again the next time on frank which will create the same query for his information without causing conflicts.

lets say i saved the query as "userqry", if i choose frank like i said, the second time, it will say, "userqry" already exists.

i know how to make it so it deletes each query each time and re-creates it, but i would like for each query to be saved because i want to use the information later.

 

[PHV]

Why not save a permanent parametised query with name criteria = Forms!YourForm!YourCombo ?

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[bluesage]

what exactly is a parametized query?

thanks

 

[PHV]

No F1 key on your keyboard ?

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884