• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 619
  • Last Modified:

Append query for sub form not working

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,
 [Forms]![frmMain]![Serial].

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!
helpappendsubformInductionCheckL.zip
0
gigifarrow
Asked:
gigifarrow
1 Solution
 
Rey Obrero (Capricorn1)Commented:
change the criteria of the query  "qryappendInductionChecksHistory"

From this

[Forms]![frmInductionChecks]![Serial]

to this


[Forms]![frmMain]![frmInductionChecks].[Form]![Serial]
0
 
gigifarrowAuthor Commented:
That works!!! Thank you for your time and help!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now