Originally Posted by
The Professor
...why, when I create a new customer record...sometimes, the SubForm Current event runs before the Main Form Current event - that has me baffled as the moment...
What baffles me is why the SubForm OnCurrent event doesn't always run before the Main Form Current event! This is the way it is supposed to run! In a Main Form/Subform scenario, the OnLoad and OnCurrent events of the Subform are always supposed to execute before those of the Main Form!
My guess is that you're going to have to relocate the code currently in the Subform OnCurrent event to somewhere else. I'd try that code in the OnEnter event of the Subform Control.
Alternatively, you could place the code to diddle with the Subform Controls in the Main Form's OnCurrent event, after the code that generates the CustID, but you'd have to adjust all of that code to reference the Controls as being Subform Controls. Personally, I'd choose the first approach!
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007