Form, Recordsource and Query result

SpawnAccess

New member
Local time
Today, 06:30
Joined
Jan 18, 2002
Messages
5
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 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?
 
Maybe Form_Activate would work. I don't know alot about this but I do know a little VB5. Sorry if this doesn't help.
 

Users who are viewing this thread

Back
Top Bottom