Form refresh

[xcao]

Hello, I used to have a Access 2003 database,now after I convert it to 2007, one of the button is not working.

The button is a close button, it used to work like this:
after close the button, the form will be closed and another form opened in background will be refreshed., and also the combo list refreshed too.
It works perfect.

The command is like this:
Forms!frmSwitchboard!frmAllSoftware.Refresh

But now after I click the button, it gives error, doesn't support the method or property.

I tried to change it to requery, but it didn't work as I wanted, it requeries the form, but not requery the combo list on it.

Basically I want to do the same thing as the refresh button on the menu bar.

Is there a way to do this?

Thanks

 

[vbaInet]

Is frmAllSoftware a subform of frmSwitchboard?

 

[xcao]

Yes.

But the form which has the close button is another form when click edit on the frmAllSoftware form

 

[vbaInet]

Perhaps this:

Forms("frmSwitchboard").Controls("frmAllSoftware").Form.Refresh

 

[xcao]

Thanks, this works perfectly.

 

[vbaInet]

You're welcome xcao.