Manipulating other open form from a form

[gazelle04]

I would like to manipulate other form from a form. For example, I want to requery the recordset of one form while working on another form. Is there a way?

[PEB]

I would like to manipulate other form from a form. For example, I want to requery the recordset of one form while working on another form. Is there a way?

MMMm Yes...

Forms!Other_Form.Requery

Hope helps...

:)

[gazelle04]

I've tried that but it won't work.

The first form was my main form and the second form is the data entry form. When I click a button on the first form to open that second form(data entry) and I close that second form the first form should be requerried to have the new data. The first form is still open while I'm working on the second form.

The first form should have already the data I've entered on the second form using requery while the're both open.

[gazelle04]

It works !!!

Sorry about that. I must have some codes that is mixed with the procedure that stops it from working.

Thanks again Peb

[gazelle04]

As a follow up to that. After I closed the 2nd form I wanted to show the data I've entered on the 2nd form to be reflected on the first form right away after I close the second form. Can I use the FindFirst method to refresh the first form. Can I use this codes on the 2nd form.

DoCmd.Close
Forms!1stform.Requery

Dim rst as recordset
Set rst = Forms!1stform.RecordsetClone
rst.FindFirst Forms!1stform.StudentID = Me.StudentID
Forms!1stform.bookmark = rst.bookmark


I did that but the 2nd form never closes and it never requeried the 1st form.

Is there any other way?

[PEB]

Hi,

DoCmd.Close

refers to the active form in the moment! So the active form is closed or the active query and what is open and active... I think that with the close method you can specify the thing you want to close!

Forms!1stform.Requery

And do you use

On error resume next ?

And about this line:
rst.FindFirst Forms!1stform.StudentID = Me.StudentID


Try only:

rst.FindFirst "[StudentID] = " & str(Me.StudentID)

[PEB]

If you want to close the second form, so it's better that you run all the code and after it close the form!

Closing maybe canceled if there is a form code that is running!

[gazelle04]

I can't make it work. Here are my codes again:

This is on the Close button of the 2nd form (the 1st form is still open.)

intStudentD = Me.StudentID ' this is a global variable

DoCmd.Close 'closes this 2nd form

Forms!1stform.Requery 'requery the Main_Univ form

Dim rst As Recordset

Set rst = Forms!1stform.RecordsetClone

rst.FindFirst "[StudentID] = " & intStudentD

Forms!Main_Univ.Bookmark = rst.Bookmark


The line Forms!1stform.Requery runs because the total records on the first form is updated when I close the 2nd form. I cant make it, please help.

[PEB]

I can't make it work. Here are my codes again:

This is on the Close button of the 2nd form (the 1st form is still open.)

intStudentD = Me.StudentID ' this is a global variable

DoCmd.Close 'closes this 2nd form

Forms!1stform.Requery 'requery the Main_Univ form

Dim rst As Recordset

Set rst = Forms!1stform.RecordsetClone

rst.FindFirst "[StudentID] = " & intStudentD

Forms!Main_Univ.Bookmark = rst.Bookmark


The line Forms!1stform.Requery runs because the total records on the first form is updated when I close the 2nd form. I cant make it, please help.

Hi,

try this:

        intStudentD = Me.StudentID      ' this is a global variable
 
        Forms!1stform.Requery 'requery the Main_Univ form
 
        Dim rst As Recordset
 
        Set rst = Forms!1stform.RecordsetClone
 
        rst.FindFirst "[StudentID] = " & Str(intStudentD)
 
        Forms!Main_Univ.Bookmark = rst.Bookmark
 
        DoCmd.Close      'closes this 2nd form
 
 

And please verify which line isn't executed! So it will be easier to check it!

:)

[gazelle04]

I found the culprit. Actually my codes are working alright. You know what is the culprit. Its the latebinding of some subforms. It can't refresh the current record of the 1st form from the 2nd form while other subforms on the 1stform are unbounded (their sourceobject property being empty)

My main form (which is the 1st form) consist of a tab control with subforms in it. I use the late binding of sourceobject property of the subforms to make the loading of the main form faster. That is the reason why its not updating the current record on the 1stform although the total number of records as shown on the status bar at bottom of the screen is updated.

I place the binding procedure on a command button for opening the 2nd form and while I'm working on the 2nd form the subforms was reconnected (their sourceobject property was being filled) at the background. And when I closed the 2nd form alas! the main form was updated on whatever I entered on the 2nd form.

Anyway thanks again for all your support in analyzing my codes.