docmd.openquery with Parameters

[Jerry8989]

I need to execute an append query from my vba code but I have to pass in a parameter. I can't set the parameter equal to a form control. I have to actually pass in a value. I don't want to use a querydef because I don't have any result sets.

Any help would be great.

Thanks

 

[Cosmos75]

Where are you getting the value that you want to pass to your parameter query?

If you have created a stored query, and want you just want to set the value of the parameter via VBA, then this KB article might be helpful.
ACC2000: "Too Few Parameters. Expected 1" Error Message