enter new data by the search result (2000)

Topic

New Reply

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

Reply | Quote

Replies

Change Set rs = frmCD.Recordset.Clone to

Set rs = Forms!frmCD.Recordset.Clone

Reply | Quote

Hi,

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

Regards

Reply | Quote

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

Reply | Quote