Share via

runtime error 2450 when form is not loaded

Anonymous
2015-12-10T14:50:41+00:00

i have form "form" i am using it for data entry

I want to Requery another form so I use

Private Sub Form_AfterInsert()

[Forms]![form1]![Child15].Requery

End Sub

its work fine when form1 is open

after close it I get error 2450

any help please

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2015-12-10T15:19:03+00:00

Hi,

check before you wreck ;-)

If CurrentProject.AllForms("form1").IsLoaded Then

    Forms!form1!Child15.Requery

End If

BTW You definitely should give your objects and controls meaningful names.

Was this answer helpful?

0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2015-12-10T16:37:45+00:00

    thanks it worked

    BTW You definitely should give your objects and controls meaningful names.

    i will try

    Was this answer helpful?

    0 comments