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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

set value of txtbox in form = select query 2
result query on a form 1
Pull a field from a form to be the criteria of an append query 0
Parameter Query Won't Run 0
Narrowing query results 16
Update Table Field Value with SQL Query 2
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Query using multiple values from one text box 7

Back
Top