append query cannot find values in form

[ChrisGow]

i am trying to create an append query that gets 2 values from one table and a 3rd value from a form.

It gets the values from the table fine but always gives me a popup asking for the value from the form.

I have used the criteria build... and selected the loaded form and the field value that I am looking for. I have also made sure that there is a value in the field on the form.

is there a reason why the query will not grab the number in the forms field? or am I jsut not doing this right.

I have done this many times on a combo box and it works fine. It is jsut not working for a field that is typed in
Can anyone help me?

 

[ChrisGow]

im not even typing anythign in, i am using the mouse and letting access tell me what fields are there and i am jsut selecting the one i want

 

[RV]

>im not even typing anythign in<

You misunderstood Pat's reply....
Re-read.

RV

 

[ChrisGow]

i got this without typing anything in
Forms![frmNewOrder]![OrderNumber]

that is the form name and field that i wanted