Recordset Clone-Can't Find Sub1 on exit of Sub2

  • Thread starter Thread starter Scooter
  • Start date Start date
S

Scooter

Ok what I want to do is have on exit of SubForm2 (frmCondition) to
RecordsetClone SubForm1 (frmAddresses). PROBLEM!! Everytime I run the
code it stops on my Main Form (frmInspectBy) declaration. It says it
can't find the Main Form RunTime Error 2465. I've checked to make sure
the proper references are checked and in proper order but it keeps
stoping.

Dim RST As Recordset, frmAddresses As Form
Dim InspBy As Field, Borough As Field, Block As Field
Dim CB As Field
Set RST = Forms!frmInspectBy!frmAddresses.Form!RecordsetClone

RST.MoveLast
With Forms![frmAddresses]
.[InspBy] = RST![InspBy]
.[Borough] = RST![Borough]
End With
End Sub


I've also tried the variation of

Set RST = Me.Parent.frmAddresses.Form!RecordsetClone

Any suggestions and help would be greatly appericated.

Please Reply to Topic NOT email thank you.
 
Hi Scooter,

try using DOT instead of BANG before RecordsetClone

Set RST = Forms!frmInspectBy!frmAddresses.Form.RecordsetClone

Set RST = Me.Parent.frmAddresses.Form.RecordsetClone


Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day ;)

remote programming and training
strive4peace2006 at yahoo.com

*
 
Thank you Crystal for your assistance. I decided to use cQuote which
seems to be giving me the results I'm looking for. Thanks again.
 
you're welcome, Scooter :) glad you got a solution

Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day ;)

remote programming and training
strive4peace2006 at yahoo.com

*
 
Back
Top