Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    330
    Thanks
    10
    Thanked 0 Times in 0 Posts

    Weird Parameter Request (Acc 97 sr2 on 95b)

    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??
    "Heading for the deep end"

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Weird Parameter Request (Acc 97 sr2 on 95b)

    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?
    Regards
    John



  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Weird Parameter Request (Acc 97 sr2 on 95b)

    Another <img src=/S/2cents.gif border=0 alt=2cents width=15 height=15>
    Did you use the Combo214 in a filter or a sort ? It can be saved in those properties of the form.
    Francois

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •