Deleting Form and Controls in VBA

[eagerlearner]

Good day everyone,

I would like to create VBA code which will be triggered byon-click event of a button on Form-A. Code should be able to do any one of thefollowing, whichever is easy.

Option 1:

1. Deleteall the controls on a form “POStatsFinal”
2. Createfive text box controls with names box1, box 2, box 3, box 4 and box 5 on “POStatsFinal”

Option 2:

1. Deletea form “POStatsFinal”
2. Createa new form and name it “POStatsFinal”
3. Createfive text box controls with names box1, box 2, box 3, box 4 and box 5 on “POStatsFinal”

Your help will be greatly appreciated.

[orange]

Please describe the "business rationale" that would use this proposed solution in plain English.
Rarely have I seen a need to delete a Form (with its controls) during operation of the database.

A Form is basically a means of displaying data that is stored in a table. The Form has a Recordsource (table or query or other) and the data in this Recordsource can be displayed in Controls on the Form. By moving to the next record in the Recordsource, the new data values are displayed in the Controls. (This is the mechanism for bound Forms).

[eagerlearner]

I have one form which calculates some parameters during on load event and I am displaying results of those calculation on this form using text boxes. This form is hidden. Using this approach, query which uses these five values from the hidden form runs at very good speed. If I calculate these five parameters when query is running the query takes exponentially long time to run.

In addition, the number of text boxes on the hidden control depends upon the number of contractors my project will have. If there are three contractors on a project then I would like to have three text boxes on the hidden form and so on. I hope this gives you little bit more to understand my request.

[orange]

Please show the form and sample calculations.
You may get some ideas this link where multiple instances of a form are used.

You could try the deleteObject see: http://msdn.microsoft.com/en-us/library/office/ff197376%28v=office.14%29.aspx

[June7]

A textbox for each contractor? Sounds like non-normalized data structure.