access can't add, rename or delete controls you requested

[tzigone]

hi
i am trying to add textboxes to form via vba.
i am firstly closing the form and then open it in design form, then
trying to add textbox. hovewever runtime error 29054 occurs and says
access can't add, rename or delete controls you requested.
what should i do?
code is like this

DoCmd.Close

DoCmd.OpenForm "Form1", acDesign, , , acFormEdit, acWindowNormal

Dim ctl As Control
Set ctl = CreateControl("Form1", acTextBox, acDetail)

 

[William Taylor]

You have to add the control to the controls collection. set a variable for
the form and the controls collection, then use the add method to add it to
the collection.

 

[tzigone]

thank you. i don't know to make a collection. does this collection b
forms' corol collection?
dim frm as form
dim ctl as control
frm=me
frm.controls.add ctl
set ctl =createcontrol(frm,....)
is this correct

 

[tzigone]

it is not correct. there is no add method like this:

 

[TC]

Is that the >running< form?

A running form can not change its own design - even by closing itself & then
reopening itself in Design view. Your only option is to pre-allocate a
suitable number of controls, set them invisible at design time, then change
the propeties at runtime to make them appear as required.

HTH,
TC