Error message: You can not paste a form into itself (1 Viewer)

shafara7

Registered User.
Local time
Today, 06:02
Joined
May 8, 2017
Messages
118
Does anyone know about the message below?

You can not paste a form (or report) into itself.
Choose a different form (or report) to use as a subform or subreport.


I got it when I tried to open a form.
It's not a Runtime Error, so it does not have a specific error number and it has an OK button.
When I clicked it, the forms open like normal.
Since it is not a VBA-related error, I cannot edit or insert 'On Error Resume Next' code.

I tried searching for the meaning of it on the internet but I couldn't find anything related to it. It's like not one ever had this problem before.
There is not even a reference about it on Microsoft's website.

If you know what it means or ever encountered this before, please let me know.
 

static

Registered User.
Local time
Today, 05:02
Joined
Nov 2, 2015
Messages
823
Seems quite self explanatory. You have a circular reference in your subforms.

Create a form in design view, save it.
Drag the form from the database window onto itself. You get that error. Click OK and the subform is removed.
Add another form.
Drag the second form onto the first form. Change source object to to the first form.
This time you don't get an error until you open the form or switch to form view.
 

Users who are viewing this thread

Top Bottom