Unbound ListBox and Form Open Event w/ SubForm

[Dave D]

I have a main form with an unbound list box. The main form also contains a bound /linked subform. When I click an item in the list box the appropriate records show in the subform. Everything works as needed except when the form is initially opened. The listbox was added using the Wizard, with the "Find a record on my form based on the value I selected in my list box" option.

No list box item is selected when the form is opened, and the subform defaults to showing some records based on I don't know what.

When the form opens how do I select the first item in the list box and get the subform to show only those related records? Or, if nothing is selected in the list box (on open) how do I get the subform to show zero records?

Thank you for any help.

[RuralGuy]

The open event is too early in the process to reference a control on a form. You would need to use the OnLoad event.

[Dave D]

Thank you. That worked for setting the selected item (ListIndex now equals 0 - the first item in the list). However, the subform still does not show the appropriate records when the form is opened even though I have "selected" the first item in the list box.

What am I missing?

[RuralGuy]

The event sequence is that first the SubForm loads then the MainForm. Try putting something in the Current Event of the form which happens *after* both the SubForm and MainForm are loaded.

[Dave D]

Thank you for your help. My problem was I had the list ordered by date while the form was ordered by ID. Once I set both to the same order by, it worked just fine.

[RuralGuy]

Thanks for posting back with your solution and success.