Results 1 to 4 of 4
  1. #1
    kavya is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2018
    Posts
    10

    Parameter Request - Loading main form with Subform Query


    I have a main form and a sub form. so, when i am trying to load the main form its asking me the parameter value.
    If i run the sub form itself (not placing that in main form)-its working good.
    I am trouble having this issue.
    Please help!

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    does the subform query have params?
    are they spelled correctly?
    does the subform box point to the correctly spelled subform or query?

    is it a crosstab query...(they ALWAYS must have params entered in the query design)

  3. #3
    kavya is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2018
    Posts
    10
    Yes,my sub form has a query= SELECT Accident.AccidentNo, Accident.AccAddrLink, Accident.AccJurid, Accident.OwnerLink, Accident.AccDate, Accident.AccTime, Accident.CorrectiveActions, Accident.AccSource, Accident.AccDateRec, Accident.AccSummary, Address.MicipalityLink, Municipality.CountyLink, Municipality.TwnVillCity, Accident.AccOrInc, Accident.AccDateClosed, Accident.AccDateClosed2FROM Municipality INNER JOIN (Address INNER JOIN Accident ON Address.AddressNum = Accident.AccAddrLink) ON Municipality.MunicipalityNum = Address.MicipalityLink;



    everything is spelled correctly.
    I think it might be because the sub form is loading before the main form. if this is the reason, what should i do now.?

  4. #4
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    1) Check the Master/child field links..

    2) Post your dB......

Please reply to this thread with any new information or opinions.

Similar Threads

  1. suppress request for a parameter
    By markjkubicki in forum Reports
    Replies: 4
    Last Post: 01-16-2018, 02:26 PM
  2. Replies: 10
    Last Post: 07-05-2017, 11:31 AM
  3. Replies: 11
    Last Post: 02-23-2017, 04:26 PM
  4. Replies: 11
    Last Post: 06-15-2016, 07:43 AM
  5. Form with parameter query subform
    By shiphtfour in forum Forms
    Replies: 11
    Last Post: 12-29-2010, 06:43 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums