I'm using MS Access 2003.
I have not been able to find any examples of using the CurrentDb.Execute command with parameters. Specifically, I have a predefined query that copies a record from one table to another, but it requires an ID parameter to know which record to copy. I'd like to run this query using CurrentDb.Execute.
Does anyone have some sample code to show how this can be done with parameters? Or is this even possible?
Thanks.
Wayne
I have not been able to find any examples of using the CurrentDb.Execute command with parameters. Specifically, I have a predefined query that copies a record from one table to another, but it requires an ID parameter to know which record to copy. I'd like to run this query using CurrentDb.Execute.
Does anyone have some sample code to show how this can be done with parameters? Or is this even possible?
Thanks.
Wayne