Welcome to SPN

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

Sign Up Now!

Blank form when parameter amended

Discussion in 'Information Technology' started by Adam@nospam.com, Jul 28, 2006.

  1. Adam@nospam.com

    Adam@nospam.com
    Expand Collapse
    Guest

    Hi All,

    I have a form that has a control source leading from two tables, I've
    done this by creating one parameter query that links the two tables.

    I want to add another table to this parameter query so that I can
    capture further information in a seperate table.

    When I add in another table to the parameter query on the controlsource
    of the form, it returns a totally blank form. All of the control
    vanish...

    Van T Dinh has advised on a previous post that "...If that the case, it
    sounds like your Form is bound to a
    RecordSource and the RecordSource does not have any row
    returned. "

    What does this mean? Also does anyone know a way around this?

    I cannot think of another solution.

    Many Thanks
    Adam
     
  2. Loading...

    Similar Threads Forum Date
    USA Utah Sikhs bring warmth to homeless with blanket donation Breaking News Dec 21, 2013
    History The Art of Firing Blanks: Jaswant Singh and the BJP Punjab, Punjabi, Punjabiyat Aug 25, 2009
    Sikh News Security blanket over Punjab as dera deadline draws close (IANS via Yahoo! India News Breaking News May 27, 2007
    Opinion Definition of Diety, Human Form, God and Waheguru Sikh Sikhi Sikhism Feb 1, 2016
    The Sikh Boy Who Developed Breasts And Grew Up To Don A Superhero Uniform Sikh Youth Sep 15, 2015

  3. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    What Van's suggesting is that adding the new parameter resulted in no rows
    being found that matched the criteria.

    Have you tried running the query outside of the form? Are any rows returned?


    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "Adam@nospam.com" <adamevans81@gmail.com> wrote in message
    news:1147689902.764394.319540@v46g2000cwv.googlegroups.com...
    > Hi All,
    >
    > I have a form that has a control source leading from two tables, I've
    > done this by creating one parameter query that links the two tables.
    >
    > I want to add another table to this parameter query so that I can
    > capture further information in a seperate table.
    >
    > When I add in another table to the parameter query on the controlsource
    > of the form, it returns a totally blank form. All of the control
    > vanish...
    >
    > Van T Dinh has advised on a previous post that "...If that the case, it
    > sounds like your Form is bound to a
    > RecordSource and the RecordSource does not have any row
    > returned. "
    >
    > What does this mean? Also does anyone know a way around this?
    >
    > I cannot think of another solution.
    >
    > Many Thanks
    > Adam
    >
     
  4. Adam@nospam.com

    Adam@nospam.com
    Expand Collapse
    Guest

    Hi,

    I've run it outside and no rows are returned. However I changed the
    link between the tables to provide some rows of data. I try this in the
    parameter query and still get a blank page.
     
  5. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    Sorry, but if you want someone to help you solve the problem, you're going
    to have to provide some details!

    You can see your tables: we can't.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no private e-mails, please)


    "Adam@nospam.com" <adamevans81@gmail.com> wrote in message
    news:1147696384.150168.315220@u72g2000cwu.googlegroups.com...
    > Hi,
    >
    > I've run it outside and no rows are returned. However I changed the
    > link between the tables to provide some rows of data. I try this in the
    > parameter query and still get a blank page.
    >
     

Share This Page