Reset Focus to Parent Form (1 Viewer)

Ok everyone, this could be something simple but it seems to be eluding me.

It sounds really complicated but please try to follow. The main form is Log details. The main form contains three tabs in which I have placed 3 sub forms. One of the tabs displays part information. On the parts tab sub form I have a button that opens the "Remove Parts" pop up form. On the pop up form I have a submit button which saves the record and closes the form.

Thus far all the code works and I am not getting any errors, but I'm also not getting the results that I want. After the pop up closes I would like to reset the focus back to the Log Details form with the new removed part entry now showing in the sub-form.

I tried a form refresh after I reset the focus but it won't refresh the list unless I click on refresh all.
+++++++++++++This is the code from the pop up+++++++++++++
++++++++++++++++++++++++++++++++++++++++++++++

***************** Here is the code from the parent form***********


***********************************************************

Any ideas?

Thanks in advance.

Hi,

Are you opening the popup form in Dialog mode? If not, I wonder if it will make a difference.

Try Parent.SetFocus and Me.Refresh (or Me.Requery)

The form opens in Dialog mode, that was one of the first things that I did when setting it up to begin with. I can set the focus to the parent form but its still not refreshing the sub-form.

Alright everyone I actually found the solution. It has to do with the order in which the code appears and I fired off the refresh right from the Submit button on the Remove Parts form.