Load added record on Main form after inserting new record from popup form

[fuonge]

Hi I have a popup form that adds a new record. It refreshes now and reloads the whole database when I close the popup form.



What I want to happen is to have the popup close, refresh then load the newly added record. How would I code that into my on close vba?


Thank you.

[June7]

Could have code in the popup form that requeries the main form then move to last record. This assumes the new record will be the last record of the main form. Otherwise, code would have to search for record ID and go to record.

Then close the popup.

[fuonge]

Thank you June7, could you write an example where it would requery then it would move to the max(PrimaryID)? Would it be like a recordset code?

[June7]

Does the main form have unfiltered RecordSource - it displays all records from table?

Forms!mainform.Requery
DoCmd.GoToRecord acDataForm, "mainformname", acLast

[fuonge]

Thank you!!