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

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

Re: "Too few parameters, expected one"

Show all headers | View raw

On Wed, 20 Jul 2016 19:28:31 +0200, Ulrich Möller <knobbi38@arcor.de>
wrote:

>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


*---
I took the filter out of the query and put a filter in code:

Set rstCorrespondence = db.OpenRecordset("Select * From
qrysbfCorrespondence Where person_id = " &
Forms!frmPeople!txtperson_id)

It worked!

Thanks everyone

-paulw

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