Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-access > #11937

Re: "Too few parameters, expected one"

Show all headers | View raw

Am 20.07.2016 um 18:13 schrieb PW:
> On Tue, 19 Jul 2016 15:33:01 -0700 (PDT), Patrick Finucane
> <patrickfinucanetx@gmail.com> wrote:
>
>> On Tuesday, July 19, 2016 at 2:22:23 PM UTC-4, PW wrote:
>>> Hi,
>>>
>>> I have a subform on a form.  The subform is based on a query.  The
>>> query and subform run fine on their own.  But when I do this, I get
>>> that error message:
>>>
>>> Dim db As Database
>>> Dim rstCorrespondence As Recordset
>>>
>>> Set db = CurrentDb()
>>>
>>> Set rstCorrespondence = db.OpenRecordset("qrysbfCorrespondence")
>>>
>>> The error msg is at the line above.
>>>
>>> The query:
>>>
>>> SELECT tblCorrespondence.*
>>> FROM tblCorrespondence
>>> WHERE
>>> (((tblCorrespondence.person_id)=[Forms]![frmPeople]![txtPerson_id]));
>>>
>>>
>>> frmPeople contains the subform on a tab.
>>>
>>> Any ideas?
>>>
>>> Thanks,
>>>
>>> -paul
>> I'm a tad confused...is frmPeople the main form or is it the subform.  I don't see how if it is the subform it can run fine with your query.
> *----
>
> The subform is on a tab on the people form and is open and is only
> accessed from the people form..
>
> -paulw
Hi,

if "txtPerson_id" is a control on a subform, you have to change the refer.

See http://access.mvps.org/access/forms/frm0031.htm for the correct 
notation.

Ulrich

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

"Too few parameters, expected one" PW <emailaddyinsig@ifIremember.com> - 2016-07-19 12:22 -0600
  Re: "Too few parameters, expected one" Ron Paii <ron81pai@gmail.com> - 2016-07-19 12:37 -0700
    Re: "Too few parameters, expected one" PW <emailaddyinsig@ifIremember.com> - 2016-07-20 10:14 -0600
  Re: "Too few parameters, expected one" Patrick Finucane <patrickfinucanetx@gmail.com> - 2016-07-19 15:33 -0700
    Re: "Too few parameters, expected one" PW <emailaddyinsig@ifIremember.com> - 2016-07-20 10:13 -0600
      Re: "Too few parameters, expected one" Ulrich Möller <knobbi38@arcor.de> - 2016-07-20 19:28 +0200
        Re: "Too few parameters, expected one" PW <emailaddyinsig@ifIremember.com> - 2016-07-20 12:51 -0600
  Re: "Too few parameters, expected one" Branislav Mihaljev <banem2@gmail.com> - 2016-07-20 22:55 -0700
    Re: "Too few parameters, expected one" PW <emailaddyinsig@ifIremember.com> - 2016-07-21 11:26 -0600

csiph-web