NavigationSubform Not Populating Records

[altemir]

Good day all ... I have a NavigationSubform container that contains a subform called "frmJobBoard". When the database is initially launched, frmJobBoard automatically displays since it is under the first navugation button loaded in the NavigationSubform navigation menu. The problem is that it shows no records. I have a frmJobBoard.Recordsource = strSQL statement in the OnOpen event of frmJobBoard. This causes the page to successfully display records, but only if the "Job Board" navigation button is clicked. How do I assign the recordsource to frmJobBoard upon initial launch to display a default recordset?



It's as if frmJobBoard is not actually opened unless the navigation button is clicked despite being displayed in full view. Where and when do I set the recordsource and issue a requery?

[June7]

You are not setting the RecordSource property in the property dialog in form design?

[altemir]

No. I'm setting the recordsource in VBA in the OnOpen event of the form.

[June7]

But you can set the property in design view so will open with default. Not sure why the code isn't working. I haven't used the Navigation form. Do you want to provide project for analysis? Follow instructions at bottom of my post.