I have a form with a macro button that opens a query and inputs the project name from the form into the project name of the query (as a linked field).That Works
Now I need to:
1.)save that newly created query as a "user" named query ie. need to prompt for user to input new query name.
2.)Make the project name field a constant not a field linked to the form.
I need to do this so that the user can create a query for each project and then link to a fax program through (ODBC) thus for each new project added a new query will need to be created.
Any ideas to stear me in the right direction would help
Mary Ann Petry
Now I need to:
1.)save that newly created query as a "user" named query ie. need to prompt for user to input new query name.
2.)Make the project name field a constant not a field linked to the form.
I need to do this so that the user can create a query for each project and then link to a fax program through (ODBC) thus for each new project added a new query will need to be created.
Any ideas to stear me in the right direction would help
Mary Ann Petry