Flashing the first record

[Guest]

Is there a way to open a form from another form and goto a specific record
before the form is displayed. At the moment my form opens and record 1 is
briefly displayed before going to the record I want. My records contain
images so it looks like the image is flashing up on record one before going
to the specific record.

 

[Wayne Morgan]

Yes, open the form hidden them make it visible after you find the record. To
do this, use the acHidden window mode argument of the DoCmd.OpenForm call.
The problem with this is that if you are trying to open the form using
acDialog, this won't work. If that is the case, then you may try turning off
the screen echo until you move to the record then turn echo on again.

DoCmd.Echo False
DoCmd.Echo True

or

Application.Echo False
Application.Echo True

Remember to turn the Echo on again in your error handler also or the user
won't be informed of the error or be able to respond to it.

 

[Guest]

Hi Wayne,

I had tried opening the form as hidden and it made no difference, The
Application.Echo False & then Application.Echo True has solved it for me.
Thanks a lot.

Dennis.