Open a form with AfterUpdate Event

[Cyber_Learning]

Hello Forum Members


I have two forms:


ReferenceLiterature with AfterUpdate Event and Split Form

Private Sub FindCompany_AfterUpdate() 
    Me.Filter = "AppliesTo=""" & FindCompany & """" 
    Me.FilterOn = True 


    DoCmd.OpenForm "ReferenceLiterature_SearchResults", acFormFS, , , , acHidden 
    Forms!ReferenceLiterature_SearchResults.RecordSource = strSQL 
    DoCmd.OpenForm "ReferenceLiterature_Searchresults", acFormFS 


End Sub

I want to open the ReferenceLiterature_SearchResults form with the filtered records, but it is currently not working.
If I remove the OpenForm, then, AfterUpdate Event itself is just working fine.
Would you please help me how this can be accomplished?

ReferenceLiterature_SearchResults with WebBowser Control and Single Form to see the PDFs.

Thank you.

[June7]

Instead of setting RecordSource, use WHERE CONDITION argument of OpenForm.

DoCmd.OpenForm "ReferenceLiterature_Searchresults", acFormFS, , "AppliesTo=""" & FindCompany & """"

How is strSQL set anyway?

[Welshgasman]

No, Me works on the current form wher the code is running.?

What is this meant to be?
ReferenceLiterature_SearchResults with WebBowser Control and Single Form to see the PDFs.

[Cyber_Learning]

Hello June 7

Your suggestion just works great, and this is what I wanted to do.
Thank you so much for your help, I sincerely appreciate it.


Hello Welshgasman

ReferenceLiterature_SearchResults with WebBowser Control and Single Form to see the PDFs has a WebBrowser Control and I can see the PDF inside the Access form after the AfterUpdate Event, while ReferenceLiterature with AfterUpdate Event and Split Form is a Split Form and the half of the Windows occupies literature titles.

Thank you again.