[AccessD] Referencing Forms with Form_

[David Emerson]

Hi Listers,

 

I have inherited a database which has the following line of code:

    Form_frmSite!sfrEquipment.Requery

 

I tried to change it as follows (replacing the "_" with "!" which is the
format I usually use):

 

    Form!frmSite!sfrEquipment.Requery

 

The first one works ok but the second one gives error 2467 "The expression
you entered refers to an object that is closed or doesn't exist.

 

Why does the first on work but the second one doesn't?  I haven't come
across the first syntax before and couldn't see anything on the web.

 

Regards

David Emerson
Dalyn Software Ltd
Wellington, New Zealand