Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    enter new data by the search result (2000)

    Hi,

    In my attached database, I try to enter new data by search result. User start search CD information first by using CD index, Date or Userfulness, then user double click the CD that they need. Another form (frmCD) pops up show current CD's No, Date and usefulness with a subform (frmCDdetail) to let user enter Song and time. Each CD have many songs. I put the code on Dbl Click property of List BOx 30 of frmCDIndex, and I got the following error message:

    Compile error: Variable not defined.

    I really appreciate all your helps!

    Regards

  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: enter new data by the search result (2000)

    Change Set rs = frmCD.Recordset.Clone to

    Set rs = Forms!frmCD.Recordset.Clone
    Regards
    John



  3. #3
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: enter new data by the search result (2000)

    Hi,

    Thanks. It's works now. But how can I set frmCDDetail have new record window instead of shows old record?

    Regards

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: enter new data by the search result (2000)

    You can set the DataEntry property of frmCDDetail (in the Data tab of the Properties window) to Yes.

Posting Permissions

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