Load Form?

[MacDermott]

The help file in Access 2000 has entries for Load and Show, suggesting a
usage similar to that in VB6.0.
But code like this fails:
Dim Frm as object
Set Frm=CurrentProject.AllForms(0)
Load Frm

with an error that the object can't be loaded or unloaded.

Anyone have any experience with this?

[Br]

MacDermott wrote:

The help file in Access 2000 has entries for Load and Show,
suggesting a usage similar to that in VB6.0.
But code like this fails:
Dim Frm as object
Set Frm=CurrentProject.AllForms(0)
Load Frm

with an error that the object can't be loaded or unloaded.

Anyone have any experience with this?

Load is a Visual Basic command, not Access.

This works...

Dim Frm As Object
Set Frm = CurrentProject.AllForms(0)
DoCmd.OpenForm Frm.Name

--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response

[Lyle Fairfield]

(I never can understand why people post simplistic answers in response
to someone who is experienced and knowlegeable and is discussing
his/her adventures with something new or not so well known.)

Load is also a VBA method. How to make it work? What we want, I think
or guess, is not a form object but a text manifestation of the form,
[similar to a .frm file in VB], which we can get with SaveAsText. We
can then copy the text into a Module, or LoadFromText it into a Module
(it's not going to be text as a form) and try Loading the Form from
that. It tries, but finds errors in the code/script/text. I'm assuming
if we could find what it wants in that text, we could modify our text
to comply and it would work.

Next question would be why? Answer: because it's there.

[Br]

Lyle Fairfield wrote:

(I never can understand why people post simplistic answers in response
to someone who is experienced and knowlegeable and is discussing
his/her adventures with something new or not so well known.)

Yeah, good on ya Lyle.

<>
--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response