FrustratedPgmr
Programmer
I am trying to run an sql statement from the forms module that will append records into another table based on the current record in the form - not a combo box or list box. I did this in my regular access pgm - upsized it to ADP and have experienced problems with all my internal parms of this type. I know it is the syntax and have tried using the & as some of your answers have suggested.
the WHERE statement gives the syntax error.
WHERE copytotable.field = me!CurrentForm!CurrentFormField
What is the correct syntax for ADP Forms?
I joined yesterday and have already found 3 solutions to some of my problems. [Gorgeous]
the WHERE statement gives the syntax error.
WHERE copytotable.field = me!CurrentForm!CurrentFormField
What is the correct syntax for ADP Forms?
I joined yesterday and have already found 3 solutions to some of my problems. [Gorgeous]