OK... newbie here.
I've figured out how to create and use a parameter query. I've seen how the paramaters can be tied to the values on a form, to replace the individual pop-ups with the single form... I'm having a hard time figuring out how to use run-time variable values from a VBA sub instead. Is there a way of supressing the parameter pop-ups from displaying, and to provide the needed values at run-time via VBA?
I've figured out how to create and use a parameter query. I've seen how the paramaters can be tied to the values on a form, to replace the individual pop-ups with the single form... I'm having a hard time figuring out how to use run-time variable values from a VBA sub instead. Is there a way of supressing the parameter pop-ups from displaying, and to provide the needed values at run-time via VBA?