Unanswered: Make a new form from another form style
In Visual Basic of the form,
Suppose I have a form "na",
I want to create another form using the VB, the form style and format as sama as the "na", all the fields are same, same positions.
Dim frm As Form
Set frm = CreateForm(, "na")
frm.RecordSource = "na"
I tried these code, the code is created based on "na", but it still needs to add the fields, and it will automatically open the design view to design, i want to VB to copy the "na" design to the new form.
How can I write? Does VB copy the same design and format to the new form?
Please let me know,
if the form design is the same, then why tinkler with it, just change the underlying recordsource for the form.
The way you are proposing sounds a nightmare - for each user you intened having a differnet form. what happens if you decide to change the design (add new features, dare I say it correct some bugs).
Do you really want to got through an unsepcifed number of forms changing the same element. Beside which you are creating a poor design: theoretically you cold bust the limits on an access model by breaking an internal magic number of controls by having an open ended number of users.
You probably could programtically copy the form design iterating through the forms collection. the help file has some good examples of what can be done - I don't think it covers precisely what you want but it should point you in the right direction