RE: Parent Form Not Recognizing SubForm Requery Criteria Code

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: neenmarie (neenmarie_at_discussions.microsoft.com)
Date: 08/26/04 

Date: Wed, 25 Aug 2004 22:01:01 -0700

Pls disregard. I did find the format for the coding.
Thank you.

"neenmarie" wrote:

> I have a subform and the following are some of its controls:
> [PartNumber], [Vendor], [Qty], [OutGoingShipNumber]
>
> It has a list box that is requeried with [Qty] lostfocus.
> The query this list box is based on has criteria set to then only show
> records matching the [PartNumber] and [Vendor] that have balances left at the
> vendor so the user can see what the originating outgoing shipper number was.
> Clicking on the record then fills in the [OutGoingShipNumber] control.
>
> This all works fine on the subform alone. But, when I open the parent form
> with the subform on it, the two criteria set in the list box query are not
> recognized...and show up as if asking for input before the form will open.
> (Forms!RcvgSubform.PartNumber) and (Forms!RcvgSubform.Vendor) Once the
> parent form is opened the requery doesn't work at all.
>
> Do I need to reference the Parent form in the query also? If so, can
> someone give me an example of the code. If that's not the problem...any
> other ideas?
>
> The Parent Form also has a [Vendor] Control that requeries a different list
> box on the subform to show all Purchase Orders and PartNumbers matching that
> vendor. The source query for this listbox has criteria set to check the
> [vendor] on the Parent.
> The [Vendor] is automatically filled in on the Subform from the Parent and
> the [PartNumber] is filled in by clicking the record from the list box. This
> part works fine.

Relevant Pages

  • Re: Referential Reference to Parent Form in Query Criteria
    ... "Jeff Boyce" wrote: ... the Child Record from the query. ... parent form (since I currently need to maintain separate subforms and ... In a standard main form/subform design, ...
    (microsoft.public.access.queries)
  • Re: Referential Reference to Parent Form in Query Criteria
    ... the Child Record from the query. ... parent form (since I currently need to maintain separate subforms and ... that reference the parent form by name). ... In a standard main form/subform design, the subform control (on the main ...
    (microsoft.public.access.queries)
  • Re: Referential Reference to Parent Form in Query Criteria
    ... "Jeff Boyce" wrote: ... the Child Record from the query. ... parent form (since I currently need to maintain separate subforms and ... In a standard main form/subform design, the subform control (on the main ...
    (microsoft.public.access.queries)
  • Parent Form Not Recognizing SubForm Requery Criteria Code
    ... The query this list box is based on has criteria set to then only show ... vendor so the user can see what the originating outgoing shipper number was. ... This all works fine on the subform alone. ... parent form is opened the requery doesn't work at all. ...
    (microsoft.public.access.formscoding)
  • Re: RecordSource parameters
    ... use code to rewrite the SQL of the subform ... > or subform query. ... >> RecordSource of the subform is a query that contains a ... every time the parent form navigates to a new ...
    (microsoft.public.access.formscoding)