• Weird Parameter Request (Acc 97 sr2 on 95b)

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Weird Parameter Request (Acc 97 sr2 on 95b)

    Author
    Topic
    #374910

    I have a form (“Quick Card”) with a combobox on it that was originally called “Combo214”. I have since changed the name and all related code to “cboAcc”. This form on its own, runs flawlessly, but I have just tried to include it as a subform in an idea I am trying, connected through Link Child Field = AccNo, which is what cboAcc is bound to, and I get a parameter box popping up and asking for the value of “Forms!Quick Card!Combo214”.

    I have used Rick Fisher’s Search and Replace to scour the entire database for “Combo214” and it tells me that it does not exist.

    I know that it involves the form “Quick Card” because my project runs fine without it.

    Any ideas Anyone??

    Viewing 1 reply thread
    Author
    Replies
    • #608066

      Not sure whether this is relevant, but it might help.

      if a control on a form is a parameter for a query, then the query will refer to it as e.g.Forms!Quick Card!Combo214

      If you make the form a subform, this reference won’t work any more. You would need something like
      forms!frmMainform![quick car].form!Combo214, and you would get an error like the one you describe.

      So to use it in two different ways you probably need two different queries.

      Does the combo box get used as the parameter for a query?

    • #608075

      Another 2cents
      Did you use the Combo214 in a filter or a sort ? It can be saved in those properties of the form.

    Viewing 1 reply thread
    Reply To: Weird Parameter Request (Acc 97 sr2 on 95b)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: