run append query using parameter values

[Monib]

Hello All,

Just wanted to ask if it is it possible to run an append query which uses parameter values instead of values from a form? If so, how?
Whenever I add the parameter statement to the criteria section the query runs but no values are appended.

 

[Isskint]

If you want to append the value of the parameter, the parameter request needs to be in the Field section.

If you want to use the parameter to restrict what is appended, then the parameter request needs to be in the Criteria section.

 

[arnelgp]

just use your parameter value in your append query:

PARAMETERS [p] TEXT (255);
INSERT INTO table1 ([Field])
SELECT [p];

 

[Monib]

Thank you soooooooooooooooooooo much Isskint! I have spent hours trying to work that out and its so straight forward.