Creating a Form from VBA 2

[crobg]

I am trying to create a form through VBA. I have got the create form metod to work but when I try to edit any of the form's properities I get an error stating that the form is not available.

Sub TestNewForm()

Dim fm As Form

Set fm = CreateForm(, "Template")

fm.Properties("Recordset") = "Customers" 'Stops here with a Run Time Error 2455, Object no longer available.
fm.Properties("Name") = "frmCustomers" 'Stops here with a Run-time error 2135, Property is read only.

End Sub

When I click help nothing comes up.

 

[PHV]

And this ?
fm.RecordSource = "Customers"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[crobg]

Sorry about that it's been a long day. That fixed that line. I still can't change the name.

Thanks.

 

[TomCologne]

For some reason, the name is a read-only property. I used
this as a workaround:

DoCmd.Close acForm, "Form1", acSaveYes
DoCmd.Rename "NewName", acForm, "Form1"


TomCologne

 

[crobg]

Thanks all for your help.