Subform Not Navigating Properly (First Time Only)

[RMittelman]

I have a strange issue.



My main form is bound to a single table. I wanted to be able to navigate records on the main form by picking a record from an unbound ListBox on the form. I've done this many times, and use the ListBox wizard to setup that ListBox.

This time a ListBox doesn't suit my needs, because I want more control over the list records, such as different fonts for different columns, and some conditional formatting in the list fields. Therefore I created a subform bound to the same table. In the subform's On_Current event, I run a public Subroutine on the Parent form, sending it the record ID from the subform. This subroutine tells the Parent form to find that record.

This is working perfectly, except for a strange quirk:

When the forms all load, the first record of the subform is selected by default. The On_Current event fires properly (I have the following code in the On_Current event to verify):

Debug.Print "form_current, order=" & Me.OrderID

The very first time I click on another subform record, nothing happens. The first record is still current, and no On_Current event fires (of course).
The next time I click on another subform record (and every time after that), that record gets focus and the On_Current event fires properly.

Maybe pertinent: If I close the main form and open the subform by itself, this doesn't happen. It only happens if the form is actually being used as a subform.

Any idea what's not working here? Thanks...

[Welshgasman]

First click is giving the focus to the subform?

[Minty]

If you make the record selectors visible you will probably "See" which record is selected.
I suspect it's not that the current event isn't firing, but that the main form isn't loaded fully, as sub form's load first.

You may need to load the subform object in the main forms load event.

[RMittelman]

If you make the record selectors visible you will probably "See" which record is selected.
I suspect it's not that the current event isn't firing, but that the main form isn't loaded fully, as sub form's load first.

You may need to load the subform object in the main forms load event.

Thanks Minty. Even without record selectors, I can see which subform record is selected, because I have conditional formatting so the current record is bold. And you are right, it's not that the event is not firing, but that the subform didn't have focus.

Rather than loading the subform in the main form's load event, I tried setting focus to the subform record from the main form's load event. This seemed to solve the issue.

[RMittelman]

First click is giving the focus to the subform?

Thanks, Welshgasman. You hit the nail on the head. In the main form's Load event (which occurs after the subform is loaded), I put a statement to set focus to the subform record and it started working properly. Thanks!