Append query for sub form not working

Posted on 2012-08-27
Medium Priority
Last Modified: 2012-08-27
Hello all,
I have a a form called "frmMain" I have a subform called "frmInductionChecks".The subform is located on one of the tabs of the main form.

I know that the structure of this form is horrible! but This is the best I could do.

On the button called" Save record" it has two queries that append One for the main form Called "frmMain": DoCmd.OpenQuery "qryappendInductionHistory", acViewNormal, acEdit

 and one for the SubForm "frmInductionChecks"  DoCmd.OpenQuery "qryappendInductionChecksHistory", acViewNormal, acEdit

The append queries have a code on the criteria that suppose to append only the data that it is in each of the form the code in the criteria looks like this for the main form,

and this for the subform, [Forms]![frmInductionChecks]![Serial]

The field for the both forms is "serial".
The main form is appending. but the subform popups showing the criteria,[Forms]![frmInductionChecks]![Serial] like it cant find the form. Experts please help!
 Thanks for all your time and help!
Question by:gigifarrow
LVL 120

Accepted Solution

Rey Obrero (Capricorn1) earned 2000 total points
ID: 38339137
change the criteria of the query  "qryappendInductionChecksHistory"

From this


to this


Author Comment

ID: 38339167
That works!!! Thank you for your time and help!

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses
Course of the Month16 days, 15 hours left to enroll

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question