Form startup problem

Hi Stephen,

I've pasted the functions below. The first one was throwing up errors when the form was first loaded. It doesn't of course fire at startup as I might have inferred but when clicking on the list. This went away when I opened the VBA editor as described in my initial post. Now the problem has gone completely!

So you can make sense of it, there are three lists: GroupList; GroupSectionList; PersonList. The query that populates GroupSectionList has the value of GroupList as a selection criteria. PersonList does the same with GroupSectionList.

The intention of the VBA is that when someone clicks on GroupList, the related Sections are displayed in GroupSectionList and also the members of PersonList that relate to the first record in GroupSectionList. This works only partially because SetFocus doesn't seem to do the same as physically clicking on the list and therefore the second function doesn't fire until GroupSectionList is clicked on. This is probably something for another thread but if you could throw some light on that as well that would be great. (ie is there a vba function that explicitly clicks on an object?).

Here is the code:

Private Sub GroupList_Click()
Me!GroupSectionList.Requery
Me!GroupSectionList.Selected(0) = True
Me!GroupSectionList.SetFocus
Me!PersonList.Requery
Me!PersonList.Selected(0) = True
End Sub

Private Sub GroupSectionList_Click()
Me!PersonList.Requery
Me!PersonList.Selected(0) = True
Me!PersonList.SetFocus
End Sub

Thanks,

Bob