Run a Query when a Form is Opened

[Stang02GT]

Is there anyway to automate a query?

I'd like to have a query run every time one of my forms is opened,

I was thinking using some VBA code with the OnOpen event.



Any ideas, help or suggestions?

[missinglinq]

This will open the query then close it. If you want it to remain open to view, omit Line # 3

Private Sub Form_Load()
  DoCmd.OpenQuery "YourQueryName" 'Run query 
  DoCmd.Close acQuery, "YourQueryName" 'Close the query
End Sub
 

Good Luck!

Linq

[Stang02GT]

This will open the query then close it. If you want it to remain open to view, omit Line # 3

Private Sub Form_Load()
  DoCmd.OpenQuery "YourQueryName" 'Run query 
  DoCmd.Close acQuery, "YourQueryName" 'Close the query
End Sub
 

Good Luck!

Linq

THANK YOU! I will give it a shot

[NeoPa]

Please remember to provide a meaningful Title for any threads started (Please Use Appropriate Titles for New Threads!). This helps to ensure that other members, and also the general public, will have a better chance of finding answers to any similar questions.

MODERATOR.