Refresh main form after inserting new record in another form.

[HeadGasket]

I probably didn't search well enough in the forum for the answer to my question.



I have a main form where information for a particular part number or job is entered. Should the part number not yet exist, Access will let you know. I have a button within the main form that opens up the Form_EnterPartNumber form which allows you to enter the new part number.

What I would hope to be able to do would be to refresh (requery?) the main form after creating a new part number and closing the Form_EnterPartNumber form..........but, keep the main form on the current record instead of resetting back to record number 1.

Is this possible?

Thanks.

[imintrouble]

Hi HeadGasket


Basically I believe you should go to the main form and in the properties to the right in the events tab just go to the OnFocus, then type Me.Requery

I'm not entirely sure if this will completely work, but I hope I've pointed you in the right direction.