Hi My name is Manic Basha, I dev

[lol]

Hi My name is Manic Basha,

I developed some databases on SQL server 7, linked them to access front end via ODBC connections,the front end version of the databases (MS Access) has a main from, on the main form(frm1), I have several fields, & also a command button to open another form(frm2), on frm2, I have a command button which will close frm2 & open frm1(done that in the VB code), I want to refresh frm1 , when I close frm2, HOW DO I DO THAT?,at the moment, I can only refresh frm1, by pressing F9 on the keyboard!

Can some body please, tell me as to how I can solve my problem?

many thanks Manic Basha ( SQL programmer)

 

[Shortie]

In the On Close event of frm2

Private Sub Form_Close()
...
Forms!frm1.Requery
...
End Sub