Why won't this form open correctly?

[Peter Kinross]

At the end of a bit of vba code, I open a form using:
DoCmd.OpenForm "frmResultsComparedToGoal", acNormal
The form has started opening like this

1.jpg

I have tried opening the form in acDesign mode, then acNormal.
I have tried .Requery on the forms recordsetclone.
I have tried opening the form in acNormal, then acDesign mode, then acNormal.
I have put a 1 second delay before the 2nd re-opening.
None of that makes any difference.
If I manually close the form then manually re-open it it looks as it should, like this

2.jpg

The record source table is:

3.jpg

I'm stumped. What am I doing wrong?

[HansV]

What happens if you clear the record source of the form in design view, and instead set the RecordSource property in the On Open (or On Load) event of the form?

[Peter Kinross]

Unfortunately that made no diff.
I am biting the bullet and not opening that form by vba. I will insert a message box advising to open the form manually.
Don't like workarounds, but sometimes .....
Thanks anyway Hans.

[CData]

the open form event is occuring before its record source is available

to debug; rather that trigger the open form - instead trigger the open of the record source - - that should tell you something.

[Peter Kinross]

Thanks CD. It appears to have fixed itself. Absolutely no idea how. The record source is a table, opening (and opening & closing) that before opening the form made no diff.

[CData]

if it is a linked table - then there could have been a glitch in the network....

[Peter Kinross]

It isn't a linked table. All tables are in this Db. So no network.
So still strange.