Welcome to SPN

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

Sign Up Now!

Message Box problem

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

  1. Saima

    Saima
    Expand Collapse
    Guest

    Hi,

    I have a problem that when opening a preview for a report, a message box
    appears to enter a parameter value. When I click cancel, the fields in the
    report do not show up, when I click ok without putting a value, the report
    shows up with all fields, when I click ok and enter a value it is also fine.

    Even after creating a new preview button and new report this message box is
    still appearing? How can I stop it from coming?

    The parameter value that it asks for is from a control that i had before but
    deleted. Still, I can't find that control in the report or the form or the
    subforms, then where else could it be?

    Some info abt the form and report. The form contains many subforms which
    appear depending on which radio button you click. There's a button called
    preview report which basically list the details on the form and the subform
    that is chosen. The subforms and subreports are all linked via child/master
    fields. And Im using Access 2003

    Thanks
    Saima
    Saima
     
  2. Loading...

    Similar Threads Forum Date
    How message of love from Sikh gurus are helping Pakistani Christians to fight forced conversions Sikh Sikhi Sikhism Oct 12, 2015
    Messages from God Sikh Sikhi Sikhism Aug 23, 2015
    Message of Guru Granth Sahib Essays on Sikhism Jan 30, 2014
    World U.N. chief's message to North Korean leader Breaking News Apr 12, 2013
    Christianity Pope Francis prays for world peace in Easter Sunday message Interfaith Dialogues Apr 1, 2013

  3. [MVP] S.Clark

    [MVP] S.Clark
    Expand Collapse
    Guest

    Post the SQL. If it has a control name that doesn't exist, then you'll be
    prompted. Same goes for field names.


    --
    Steve Clark, Access MVP
    FMS, Inc
    http://www.fmsinc.com/consulting
    Professional Access Database Repair
    *FREE* Access Tips: http://www.fmsinc.com/free/tips.html

    "Saima" <saum123@gmail.com(donotspam)> wrote in message
    news:14C785D8-FDFD-41A4-A0B7-AB740068C81A@microsoft.com...
    > Hi,
    >
    > I have a problem that when opening a preview for a report, a message box
    > appears to enter a parameter value. When I click cancel, the fields in the
    > report do not show up, when I click ok without putting a value, the report
    > shows up with all fields, when I click ok and enter a value it is also
    > fine.
    >
    > Even after creating a new preview button and new report this message box
    > is
    > still appearing? How can I stop it from coming?
    >
    > The parameter value that it asks for is from a control that i had before
    > but
    > deleted. Still, I can't find that control in the report or the form or the
    > subforms, then where else could it be?
    >
    > Some info abt the form and report. The form contains many subforms which
    > appear depending on which radio button you click. There's a button called
    > preview report which basically list the details on the form and the
    > subform
    > that is chosen. The subforms and subreports are all linked via
    > child/master
    > fields. And Im using Access 2003
    >
    > Thanks
    > Saima
    > Saima
     
  4. Peter Hibbs

    Peter Hibbs
    Expand Collapse
    Guest

    Hi Saima

    I have been caught with this one before. Try looking in the Sorting and
    Grouping dialog on the tool-bar, it might be in there.

    --
    Peter Hibbs
     
  5. Saima

    Saima
    Expand Collapse
    Guest

    Thanks for your time guys. I finally found it after looking at each of the
    subforms fields (and as a result very dry eyes). Thanks for you help!! :)
     

Share This Page