As part of my FE interface, I am importing a form from the server to replace
an existing form, updating it with any recent revisions. The issues I am
having though are:

I have the code of frm_B checking a version tag on frm_A when frm_A is
loaded. If the version tag is not current, then I close frm_A, download the
most recent version of frm_A from the network to replace it, then re-open
frm_A.

I have attempted this 2 different ways, and each of them results in the same
error: 'Can't Delete a form that is open'

Method 1:
Close frm_A
DeleteObject (error!)
TransferDatabase
OpenForm

Method 2:
Close frm_A
TransferDatabase (alternate name)
DeleteObject frm_A (error!)
Rename frm_Alt to frm_A

Is there a way of either forcing a close, recognizing an actual close,
etc...?
(There are other issues at stake which keeps me from storing the version
elsewhere)

Why not simply replace the front-end? Far less trouble.

Take a look at the free Auto FE Updater Tony Toews has at
http://www.granite.ab.ca/access/autofe.htm

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Can Of Worms" <(E-Mail Removed)> wrote in message
news:4AACFC09-06DD-4092-A892-(E-Mail Removed)...
> As part of my FE interface, I am importing a form from the server to
> replace
> an existing form, updating it with any recent revisions. The issues I am
> having though are:
>
> I have the code of frm_B checking a version tag on frm_A when frm_A is
> loaded. If the version tag is not current, then I close frm_A, download
> the
> most recent version of frm_A from the network to replace it, then re-open
> frm_A.
>
> I have attempted this 2 different ways, and each of them results in the
> same
> error: 'Can't Delete a form that is open'
>
> Method 1:
> Close frm_A
> DeleteObject (error!)
> TransferDatabase
> OpenForm
>
> Method 2:
> Close frm_A
> TransferDatabase (alternate name)
> DeleteObject frm_A (error!)
> Rename frm_Alt to frm_A
>
> Is there a way of either forcing a close, recognizing an actual close,
> etc...?
> (There are other issues at stake which keeps me from storing the version
> elsewhere)