Auto Refresh - ReApply Filter

[jnoonan22]

My initial form is a datasheet with a list of invoices which was filtered on open to include only invoices pertaining to a specific project. Clicking on an invoice opens the invoice detailed input form where data can be edited in dialog. Clicking on the "new/blank" line opens the invoice detailed input form for adding data in dialog.

After adding a new invoice in the detailed input form, I save and close that which takes me back to the datasheet parent form I initially clicked on. I cannot for the life of me figure out how to have that form re-apply the filter so that the new invoice just created shows up in the list of invoices. If I manually unclick and re-click the filter icon at the bottom, it will appear, but I can't get the form to do this automatically. I've tried "on focus", "on activate", and several other events to try and get this to happen, but for some reason closing out the detailed form (which I thought automatically returned focus to the datasheet form) does not trigger an event.

The only way I have been able to make this somewhat work is by having the datasheet form close out when focus shifts to the new form, then reopen the datasheet form when I close the detailed input form, which of course re-filters the data to now include the new info. This however seems excessive; there has to be a cleaner way to simply re-filter the datasheet form by simply closing out the input form...right? Thanks in advance.

[June7]

What is the code that opens the detail input form? Open the form in Dialog mode and code execution by the main form will be suspended until the detail form closes.

What I do:

DoCmd.OpenForm "formname", , , , , acDialog
Me.Requery

[jnoonan22]

Well I tried using your code but I must be doing something wrong. All my macros and events have been setup using the macrobuilder. I deleted my current openform macro and recreated using your code:
Private Sub INVOICE_NUMBER_Click()
DoCmd.OpenForm "formPROJECT REVENUES", , "ProjectID", "[PROJECT]='" & [PROJECT] & "'", acFormEdit, acDialog
Me.Requery
End Sub

Now when I click on my field, nothing happens; the form doesn't even open. Sorry, I've never written procedures for Access directly as code so I'm sure I've missed some things.

[June7]

Try without "ProjectID" in the FilterName property. I've never used the FilterName argument, only the WhereCondition.

The WhereCondition should probably use ProjectID.

"ProjectID=" & Me!ProjectID

[jnoonan22]

Okay thanks! I had to go into my database options and enable content for the script to execute apparently. That's really frustrating i had no idea the script wasn't even executing. The code executes perfectly now and refreshes just as i intended. Thanks for the help!

[jnoonan22]

I have another form I'm trying to accomplish something similar on, only I'm refreshing the dsum function behind the field rather than requerying. I'm employing the dialog format which worked as you previously mentioned, but when i debug the execution it continues to execute and refresh the field regardless of the fact that a new form opened in dialog mode, so it doesn't refresh after i've input data in the newly opened form like i intended for it to. Why does the prior situation you helped me resolve freeze the code execution until the dialog is closed but not the new refresh code? Thanks again for your help, i appreciate it!

[June7]

Don't think I've ever had a domain aggregate function in those circumstances. The DSum is in a textbox? Well, that isn't VBA so it is not influenced by the acDialog.