help

[Darren Spooner]

i have a query that i use the append info to another database, but in this
query there is a parameter. in my code i have DoCmd.OpenQuery "qryArchive",
acNormal, acEdit
DoCmd.RunCommand acCmdRun
i want the parameter to come from the form without me haveing to enter it
when the query ask me how do i do this??

 

[Kelvin]

Your code is running twice. The .OpenQuery function will run the query so
you don't need the second line. To get the criteria from the form, replace
your current criteria with.

Forms![nameOfForm]![nameOfTextBox]

Kelvin

 

[Darren Spooner]

thanks that worked

Your code is running twice. The .OpenQuery function will run the query so
you don't need the second line. To get the criteria from the form, replace
your current criteria with.

Forms![nameOfForm]![nameOfTextBox]

Kelvin

i have a query that i use the append info to another database, but in this
query there is a parameter. in my code i have DoCmd.OpenQuery "qryArchive",
acNormal, acEdit
DoCmd.RunCommand acCmdRun
i want the parameter to come from the form without me haveing to enter it
when the query ask me how do i do this??