Value not showing up in query results

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top