Turn off a system message in a module

[Fiat77]

I have the following module

DoCmd.SetWarnings False
DoCmd.Echo False, ""
DoCmd.Hourglass True
DoCmd.OpenForm "z_FFil2_frmCustom_800_600", acDesign, "", "", , acNormal
DoCmd.OpenForm "z_FFil2_frmCustom_800_600", acNormal, "", "", , acNormal
DoCmd.Maximize
DoCmd.SetWarnings True
I need to open this form briefly in design view to trigger a recordsource refresh. Everything works fine except that if this is opened in a multiuser state, they get this wanung box pop up.

You do not have exclusive access to the database at this time. If you proceed to make changes you may not be able to save them later.

Now if the user clicks OK they can move right past this message fine. But is there a way to make this go away. I try to use SendKeys and i get an error that I need an Add In Utility. How can I get this message to disappear?

 

[lupins46]

Why can't you just refresh the form recordset using:
me.refresh

 

[lewds]

Hi...

If your database is a FrontEnd - BackEnd configuration this should not be a problem.

This allows for custom FrontEnds on each machine and allows for changes in Forms in a multiuser enviroment(if you must go to design mode)

If you are just changing the recordsource of the Form then me.recordsource = "Some Record Source"
me.refresh

as lupins46 suggested?