Alter External Access Forms in DAO

[JD]

Does anyone know how to modify the contents (ie. controls,
properties etc) of an external MS Access form, from your
current access database using DAO?
I've been successful at doing this using
OpenCurrentDatabase but I have a need for do this in DAO.


Thanks

 

[Douglas J. Steele]

You can only manipulate forms that are opened in Design mode.

As far as I'm aware, the only way to open a form in design mode is to use
the OpenForm method of the DoCMd object. In order to have this work in the
correct database, you must have a new Application object instantiated, which
means you must use the OpenCurrentDatabase method.