Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Form -> Subform

Discussion in 'Information Technology' started by PeterM, Jul 28, 2006.

Tags:
  1. PeterM

    PeterM
    Expand Collapse
    Guest

    I have Form A and on Form A is SubForm B. Form A is a single view record
    type form. SubForm B is a continuous form. The two forms are not linked
    together. When you select an entry on SubForm B it passes the vlaues from
    SubForm B to hidden field on Form A and then SubForm B issues a requery of
    Form A. The query for Form A is based on those hidden fields.

    The probem is that when Form A does a requery, it also requeries SubForm B
    which I do not want it to do. Why is SubForm B doing a requery when a
    requery of Form A is issued? How do I prevent SubForm B from doing a requery?

    Thanks in advance for your help!
     
  2. Loading...


  3. PC Datasheet

    PC Datasheet
    Expand Collapse
    Guest

    Have you considered setting the LinkMaster and LinkChild properties rather
    than using your query method to coordinate the forms?


    --
    PC Datasheet
    Your Resource For Help With Access, Excel And Word Applications
    Over 1175 users have come to me from the newsgroups requesting help
    resource@pcdatasheet.com



    "PeterM" <PeterM@discussions.microsoft.com> wrote in message
    news:950FB8A0-C943-496C-A46C-9CF548911C80@microsoft.com...
    >I have Form A and on Form A is SubForm B. Form A is a single view record
    > type form. SubForm B is a continuous form. The two forms are not linked
    > together. When you select an entry on SubForm B it passes the vlaues from
    > SubForm B to hidden field on Form A and then SubForm B issues a requery of
    > Form A. The query for Form A is based on those hidden fields.
    >
    > The probem is that when Form A does a requery, it also requeries SubForm B
    > which I do not want it to do. Why is SubForm B doing a requery when a
    > requery of Form A is issued? How do I prevent SubForm B from doing a
    > requery?
    >
    > Thanks in advance for your help!
    >
    >
     
  4. PeterM

    PeterM
    Expand Collapse
    Guest

    yes, there is some processing that I need to do that prevents me from linking
    the forms

    how do I prevent the requery?

    "PC Datasheet" wrote:

    > Have you considered setting the LinkMaster and LinkChild properties rather
    > than using your query method to coordinate the forms?
    >
    >
    > --
    > PC Datasheet
    > Your Resource For Help With Access, Excel And Word Applications
    > Over 1175 users have come to me from the newsgroups requesting help
    > resource@pcdatasheet.com
    >
    >
    >
    > "PeterM" <PeterM@discussions.microsoft.com> wrote in message
    > news:950FB8A0-C943-496C-A46C-9CF548911C80@microsoft.com...
    > >I have Form A and on Form A is SubForm B. Form A is a single view record
    > > type form. SubForm B is a continuous form. The two forms are not linked
    > > together. When you select an entry on SubForm B it passes the vlaues from
    > > SubForm B to hidden field on Form A and then SubForm B issues a requery of
    > > Form A. The query for Form A is based on those hidden fields.
    > >
    > > The probem is that when Form A does a requery, it also requeries SubForm B
    > > which I do not want it to do. Why is SubForm B doing a requery when a
    > > requery of Form A is issued? How do I prevent SubForm B from doing a
    > > requery?
    > >
    > > Thanks in advance for your help!
    > >
    > >

    >
    >
    >
     
  5. StopThisAdvertising

    StopThisAdvertising
    Expand Collapse
    Guest

    "PC Datasheet" <NoSpam@Spam.Com> schreef in bericht news:gg28g.401$x4.233@newsread3.news.pas.earthlink.net...
    --
    > PC Datasheet
    > Your Resource For Help With Access, Excel And Word Applications 'Resource ????
    > Over 1175 users have come to me from the newsgroups requesting help '1175 users ????
    > resource@pcdatasheet.com


    --
    To Steve:
    Been away for a little while ??
    Since no-one wants your advertising/job hunting here you are allowed to stay away longer!
    Over 800 !! users from the newsgroups have visited the website to read what kind of a 'resource' you are... (rapidly increasing..)

    To the original poster:
    Most people here have a common belief that the newsgroups are for *free exchange of information*.
    But Steve is a notorious job hunter in these groups, always trying to sell his services.
    And he is known here as a shameless liar with no ethics at all.

    Before you intend to do business with him look at:
    http://home.tiscali.nl/arracom/whoissteve.html

    Arno R
     
  6. Dan Dang

    Dan Dang
    Expand Collapse
    Guest

    If Form A and Form B aren't really link then you can design a unbound form
    instead.

    Steps:
    1.Make a unbound form: no record source
    2.Place form A and form B on to that unbound form.
    3.Change code to reflect the unbound form.
    a. I'm assuming you're using form reference to requery formA, so you just
    need
    to change your code accordingly to reflect the new setup.
    4.Now form A should be completely seperate from form B. As a result when you
    requery form A, you will only be requery that form.




    "PeterM" wrote:

    > I have Form A and on Form A is SubForm B. Form A is a single view record
    > type form. SubForm B is a continuous form. The two forms are not linked
    > together. When you select an entry on SubForm B it passes the vlaues from
    > SubForm B to hidden field on Form A and then SubForm B issues a requery of
    > Form A. The query for Form A is based on those hidden fields.
    >
    > The probem is that when Form A does a requery, it also requeries SubForm B
    > which I do not want it to do. Why is SubForm B doing a requery when a
    > requery of Form A is issued? How do I prevent SubForm B from doing a requery?
    >
    > Thanks in advance for your help!
    >
    >
     
  7. PC Datasheet

    PC Datasheet
    Expand Collapse
    Guest

    There is some sort of connection between the record in Form A and the
    records in Form B; perhaps through their recordsources. When the record
    changes in Form A from the query, it causes the records to change in the
    subform. This is the essence of how a mainform/subform works. If you explain
    what is in the main form and what is in the subform, why you have a subform
    and what processing you need to do that prevents you from linking the forms,
    maybe we can help solve your problem.

    --
    PC Datasheet
    Your Resource For Help With Access, Excel And Word Applications
    Over 1175 users have come to me from the newsgroups requesting help
    resource@pcdatasheet.com



    "PeterM" <PeterM@discussions.microsoft.com> wrote in message
    news:C4A263B8-5B3A-423E-9A77-BF95E8261A74@microsoft.com...
    > yes, there is some processing that I need to do that prevents me from
    > linking
    > the forms
    >
    > how do I prevent the requery?
    >
    > "PC Datasheet" wrote:
    >
    >> Have you considered setting the LinkMaster and LinkChild properties
    >> rather
    >> than using your query method to coordinate the forms?
    >>
    >>
    >> --
    >> PC Datasheet
    >> Your Resource For Help With Access, Excel And Word
    >> Applications
    >> Over 1175 users have come to me from the newsgroups requesting
    >> help
    >> resource@pcdatasheet.com
    >>
    >>
    >>
    >> "PeterM" <PeterM@discussions.microsoft.com> wrote in message
    >> news:950FB8A0-C943-496C-A46C-9CF548911C80@microsoft.com...
    >> >I have Form A and on Form A is SubForm B. Form A is a single view
    >> >record
    >> > type form. SubForm B is a continuous form. The two forms are not
    >> > linked
    >> > together. When you select an entry on SubForm B it passes the vlaues
    >> > from
    >> > SubForm B to hidden field on Form A and then SubForm B issues a requery
    >> > of
    >> > Form A. The query for Form A is based on those hidden fields.
    >> >
    >> > The probem is that when Form A does a requery, it also requeries
    >> > SubForm B
    >> > which I do not want it to do. Why is SubForm B doing a requery when a
    >> > requery of Form A is issued? How do I prevent SubForm B from doing a
    >> > requery?
    >> >
    >> > Thanks in advance for your help!
    >> >
    >> >

    >>
    >>
    >>
     

Share This Page