Form, Recordsource, On open event

[SpawnAccess]

I have a form with Recordsource based on a stored procedure in an MSDE SQL server.
I pass an Openargs value to the form from a seek-form, to find a specific record in the On open event.
BUT! The On open event does not wait until the form / recordset is populated, and so I can't find more than the first 50 first records in the Query result...out of over 5000!
How do I make Access / VBA wait until all records have been fetched?

 

[Travis]

Have you tried the Load Event?

 

[Pat Hartman]

It seems to be a waste of a "real" RDBMS to pull all those rows across the network when you really want only one. Why not use a parameter query?

PS - please don't keep posting the same question. Continue an earlier thread until you get the help you need or determine that no one here has the expertise to solve your problem.