troubleshooting Question

Append query suppose to append selected record but appending all the records

Avatar of gigifarrow
gigifarrow asked on
Microsoft AccessSQL
9 Comments6 Solutions362 ViewsLast Modified:
Hello Experts!

I have append query that is suppose to append based on the selection on the form. Instead of appending the selected record is appending all the records. I am not getting a error message. I have each field that appends based on what is in the form.

For example:FinalQCByQCLead: [Forms]![frmCompletionRecord]![FinalQCByQCLead]

This is done on all the fields.

Attached is a example of my codes. On the form I do not have all the fields on it. But It should still append what I have on the form.
Bill Ross

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 6 Answers and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 6 Answers and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros