Can Form2 requery Form1 On Close of Form2? (1 Viewer)

[jlathem]

Does anyone know the Syntax to requery form1 On Close of form2?

I put in the On Close of Form2 :
Forms!form1.Requery

But that didn’t work.

Any suggestions?

As always thanks for any ideas to suggestions.

James

 

[gemma-the-husky]

why do you think it isnt working? do you get an error?

 

[jlathem]

why do you think it isnt working? do you get an error?

Because the form doesn't requery and I have tried Forms!form1.Refresh and get nothing.

It's ok though. I sent the database on as it was. I just wish I could have made it a little cleaner or functional with the requery to refresh.

Dave I want to thank you for all your assistance with these two projects. Maybe one day I can return the favor.

James

 

[AccessBlaster]

Does anyone know the Syntax to requery form1 On Close of form2?

I put in the On Close of Form2 :
Forms!form1.Requery

But that didn’t work.

Any suggestions?

As always thanks for any ideas to suggestions.

James

James,
One trick you can do, is to close Form1. If you use a button to open form2, put this in the buttons on click event DoCmd.Close acForm, "form1" then in form2 close event, put this DoCmd.OpenForm "form1" This requerys form1 with very little code.

Richard

 

[jlathem]

Great idea Richard.

Thanks!

James