How do I get a form to display itself before a msgbox on Form_Load?

[Chrisso]

Hi All

I have a form that displays a single record's data.

On Form_Load I check that all the data is present for this record (as
we have legacy data) and then issue a msgbox that tells the user that
something is missing and please fill it in.

The trouble is that my msgbox is displayed *before* the form is
displayed. Therefore, some of my users see the msgbox and scratch
their heads confused as they cannot (yet) see the associated data that
is causing the problem.

They will (of course) see the record as soon as they OK my msgbox but
I would like to display the form first and *then* issue the msgbox -
this way the user can see the message and the data at once.

How do I get the form to display itself before my msgbox? I have
tried .Repaint with no luck.

Cheers for any ideas,
Chrisso

 

[Graham Mandeno]

Hi Chrisso

Try using Form_Current instead of Form_Load.

This is a more logical place for the code anyway, because presumably every
record would need to be checked, if the form were able to show more than one
record.

 

[Chrisso]

Hi Chrisso

Try using Form_Current instead of Form_Load.

This is a more logical place for the code anyway, because presumably every
record would need to be checked, if the form were able to show more than one
record.
--
Good Luck  

Graham Mandeno [Access MVP]
Auckland, New Zealand

Hi All

I have a form that displays a single record's data.

On Form_Load I check that all the data is present for this record (as
we have legacy data) and then issue a msgbox that tells the user that
something is missing and please fill it in.

The trouble is that my msgbox is displayed *before* the form is
displayed. Therefore, some of my users see the msgbox and scratch
their heads confused as they cannot (yet) see the associated data that
is causing the problem.

They will (of course) see the record as soon as they OK my msgbox but
I would like to display the form first and *then* issue the msgbox -
this way the user can see the message and the data at once.

How do I get the form to display itself before my msgbox? I have
tried .Repaint with no luck.

Cheers for any ideas,
Chrisso- Hide quoted text -

- Show quoted text -

Ah yes - that makes sense. Thanks.

Chrisso