View Full Version : Form, Recordsource and Query result


SpawnAccess
01-18-2002, 02:51 AM
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?

rt49
01-20-2002, 11:12 PM
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.