Problem with Form MoveSize

[tomatdeepwater]

I was looking in the archives at thread702-840818 for an answer and decided to repost it here.

--------

I make a lot of use of forms that have the .MoveSize statement in their opening sequence. I usually put it in the OnLoad event. For some reason, a long time ago, I found that they would not do their work if in the OnOpen or OnActivate.

Now I have an form who I assign its recordsource dynamically.

For some reason, the OnLoad event does not fire, so I put my MoveSize statement in the OnOpen event ... still does not size my form. I AM useing DoCmd.Restore, but that does not seem to matter.

I would appreciate any info that would help me understand how to make my .MoveSize commend size my form.

Thanks!

 

[Frink]

Hallo,

A solution may be to have a dummy table, and set the recordsource in the table design. You can always clear the recordsource later in the startup if you need to.

I appreciate that this is a workaround, rather than a solution. Anyone else have any ideas?

- Frink