Re: Duplicate the record in form and subform

The request for a parameter means you have a name Access doesn't recognise. So some name in the SQL statement is no correct.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Andy" <Andy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0555F0B6-2296-45D1-BFDB-C8EBBE414493@xxxxxxxxxxxxxxxx
Thanks, Beetle & Allen,

Have changed the code as below but got an error message "Error#3061,
parameter not much enough, expected is 1" caused by below line :

DBEngine(0)(0).Execute strSql, dbFailOnError

Appreciate your expert commnts! Thanks in advance!

.

Relevant Pages

  • Re: subform records
    ... open the Immediate Window. ... Copy the SQL statement there, and paste it into SQL View in a new query. ... Allen Browne - Microsoft MVP. ... tblSet, with SetID primary key, and OrderID foreign key. ...
    (microsoft.public.access.formscoding)
  • Re: Same date range in main and sub form
    ... You need to concatenate together the parts to make up the SQL string ... it will look like the SQL statement you original ... Allen Browne - Microsoft MVP. ... well as the name of the query on which the form is based. ...
    (microsoft.public.access.forms)
  • Re: Seek Method on Network
    ... dbOpenDynaset instead of dbOpenTable. ... Use a SQL statement to grab only the records you want, sorted as desired, ... Allen Browne - Microsoft MVP. ... Set rs1 = CurrentDb.OpenRecordset ...
    (microsoft.public.access.modulesdaovba)
  • Re: How to dynamically create an Access 2003 form
    ... Allen Browne - Microsoft MVP. ... When I omitted the parm, it prompted me for it and them ran. ... It prevents you creating an MDE for the end user. ... examine the SQL statement of the view (which is presumably in the ...
    (microsoft.public.access.forms)
  • Re: What DAO do , Can ADO also do ?
    ... Can't change text field size using DAO; ... The SQL statement you give as an example can be ... > Allen Browne - Microsoft MVP. ... rather than allenbrowne at mvps dot org. ...
    (microsoft.public.access.modulesdaovba)
Loading