Running queries called by macro through form

[Bronte1226]

I am trying to set up a process through a macro to run when a field on a form is updated or changed. My problem arises when I am trying to force the query being called by the macro, triggered by the form to only append the current record. I tried adding criteria to the query: [Me]![Forms]![Work Order]![WO Number]
but that didn't work, it just asks for the WO number and even if I put it into the input box it still errors out. I set up an append query and an updated query to run when the macro is called by the form event. I must be missing a step or something. What am I doing wrong?

 

[carrick]

I'm not sure I fully understand all your steps, but it seems the reference within the query is incorrect. If you use ME to reference a control, you are meaning a control within the same item (in this case, the query). The FORMS collection is what you want to use instead. I think [Forms]![Work Order]![WO Number] would be the correct syntax.