How to refresh an access form

Question

I am building an MS Access application in which all the forms are modal  However  after data change in a form  I want to refresh the parent form of this form with newer data  Is there any way to do it  To elaborate further    Consider there are two forms  Form A and Form B  Both are modal form  From Form A  I initiate Form B  and now Form B has the user attention  But at the close of form B  I want to refresh the Form A  Is there a way to do it

User · Answer

I recommend that you use REQUERY the specific combo box whose data you have changed AND that you do it after the Cmd Close statement   that way  if you were inputing data  that data is also requeried     DoCmd Close Forms  Form Name   Combo Box Name  Requery   you might also want to point to the recently changed value  Dim id As Integer id   Me  Index Field  DoCmd Close Forms  Form Name   Combo Box Name  Requery Forms  Form Name   Combo Box Name    id   this example supposes that you opened a form to input data into a secondary table     let us say you save School Index and School Name in a School table and refer to it in a Student table  which contains only the School Index field    while you are editing a student  you need to associate him with a school that is not in your School table  etc etc

User · Answer

No  it is like I want to run Form Load   of Form A if it is possible   -- Varun Mahajan  The usual way to do this is to put the relevant code in a procedure that can be called by both forms  It is best put the code in a standard module  but you could have it on Form a   Form B   Sub RunFormALoad      Forms FormA ToDoOnLoad End Sub   Form A   Public Sub Form Load       ToDoOnLoad End Sub      Sub ToDoOnLoad       txtText    Hi  End Sub

User · Answer

You can repaint and   or requery   On the close event of form B   Forms FormA Requery   Is this what you mean

User · Answer

No  it is like I want to run Form Load   of Form A if it is possible   -- Varun Mahajan  The usual way to do this is to put the relevant code in a procedure that can be called by both forms  It is best put the code in a standard module  but you could have it on Form a   Form B   Sub RunFormALoad      Forms FormA ToDoOnLoad End Sub   Form A   Public Sub Form Load       ToDoOnLoad End Sub      Sub ToDoOnLoad       txtText    Hi  End Sub

User · Answer

I recommend that you use REQUERY the specific combo box whose data you have changed AND that you do it after the Cmd Close statement   that way  if you were inputing data  that data is also requeried     DoCmd Close Forms  Form Name   Combo Box Name  Requery   you might also want to point to the recently changed value  Dim id As Integer id   Me  Index Field  DoCmd Close Forms  Form Name   Combo Box Name  Requery Forms  Form Name   Combo Box Name    id   this example supposes that you opened a form to input data into a secondary table     let us say you save School Index and School Name in a School table and refer to it in a Student table  which contains only the School Index field    while you are editing a student  you need to associate him with a school that is not in your School table  etc etc

User · Answer

Requery  is indeed what you what you want to run  but you could do that in Form A s  On Got Focus  event  If you have code in your Form Load  perhaps you can move it to Form Got Focus

User · Answer

to refresh the form you need to type - me refresh in the button event on click

User · Answer

No  it is like I want to run Form Load   of Form A if it is possible   -- Varun Mahajan  The usual way to do this is to put the relevant code in a procedure that can be called by both forms  It is best put the code in a standard module  but you could have it on Form a   Form B   Sub RunFormALoad      Forms FormA ToDoOnLoad End Sub   Form A   Public Sub Form Load       ToDoOnLoad End Sub      Sub ToDoOnLoad       txtText    Hi  End Sub

User · Answer

Requery  is indeed what you what you want to run  but you could do that in Form A s  On Got Focus  event  If you have code in your Form Load  perhaps you can move it to Form Got Focus

User · Answer

You can repaint and   or requery   On the close event of form B   Forms FormA Requery   Is this what you mean

User · Answer

No  it is like I want to run Form Load   of Form A if it is possible   -- Varun Mahajan  The usual way to do this is to put the relevant code in a procedure that can be called by both forms  It is best put the code in a standard module  but you could have it on Form a   Form B   Sub RunFormALoad      Forms FormA ToDoOnLoad End Sub   Form A   Public Sub Form Load       ToDoOnLoad End Sub      Sub ToDoOnLoad       txtText    Hi  End Sub

User · Answer

Requery  is indeed what you what you want to run  but you could do that in Form A s  On Got Focus  event  If you have code in your Form Load  perhaps you can move it to Form Got Focus

User · Answer

You can repaint and   or requery   On the close event of form B   Forms FormA Requery   Is this what you mean

User · Answer

Requery  is indeed what you what you want to run  but you could do that in Form A s  On Got Focus  event  If you have code in your Form Load  perhaps you can move it to Form Got Focus

User · Answer

to refresh the form you need to type - me refresh in the button event on click

User · Answer

You can repaint and   or requery   On the close event of form B   Forms FormA Requery   Is this what you mean

[vba] How to refresh an access form

Examples related to vba

Examples related to ms-access

Examples related to refresh