help

  • Thread starter Thread starter Darren Spooner
  • Start date Start date
D

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??
 
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
 
thanks that worked

Kelvin said:
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 said:
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??
Click to expand...
Click to expand...
 
Back
Top