Can't test this with a Split Form, right now, but a problem with Access, vis-à-vis Record Counts, is that Access doesn't necessarily load an entire RecordSet when a Form first loads...and this quirk may be particularly problematic when loading the new Split Form. To facilitate custom Record Counts, in other types of Forms, the following can be used, and may be helpful, in your situation; it simply forces the Access Gnomes to load all of the RecordSet, on opening the Form, by moving to the Last Record then returning to the First Record:
Code:
Private Sub Form_Load()
DoCmd.GoToRecord , , acLast
DoCmd.GoToRecord , , acFirst
End Sub
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007