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

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

"Too few parameters, expected one"

Show all headers | View raw

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

Back to comp.databases.ms-access | Previous | Next — 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