Value not showing up in query results

D

Derek Wittman

Good morning,
I'm working on an Append query (SQL Insert) with current values inputted on
a form. I have a value that just isn't making it into the results when I
view them. The value should be a 10 digit fixed number. It is on the form,
but I cannot see that it's making its way into the query results.

The form's textbox control is Forms!frmNewProject.ProjectID and the query
field is Expr3: [Forms]![frmNewProject].[ProjectID] so I just don't get it.
I'm probably missing something VERY simple, but if someone could give me a
push in the right direction, I'd really appreciate it.

Thank you very much!
Derek
 
J

JL

Hi,
Is your form's textbox name "Forms!frmNewProject.ProjectID" or "ProjectID"?
It should be just "ProjectID". Then your query will reference by using
"forms![formname]![formfield]"

I hope this will solve your problem.
 
Top