I have information on a form not bound with the Form Name Form1 and the text box is called Order No. I would like to append this to a Order Table. I have been trying
in [Forms]![Form1]![Order No]and when I try to run it I get a criteria box coming up to say it does not recognise that.

HELP!!!

I hope that my reply to your second posting will help