VBA Dynamic Customer Form Wizard

[brorick]

Does anyone know how to mimic the Form Wizard in Access using VBA. I have a FormTemplate Table with the following fields and data. The field name is to the left of the colon and the comma seperates each record within the table for that column.

FormID: 1, 1, 1, 1, 1, 1
Required: No, No, Yes, No, No, No
FieldName: DateAdded, ProdType, ProdName, Cost, Discontinued, Notes
Caption: Date Added, Type, Product, , ,
DataType: Date/Time, Text, Text, Currency, Yes/No, Memo
Format: Short Date, , ,Currency, Yes/No,
DisplayControl: ,Check Box,,,,
DefaultValue:,Fruit,,,No,

I would like the option to use a Custom Form Wizard that would allow me to select the FormID I would like to base the form on and the wizard would go through the FormTemplate table and create the controls on the form accordingly.

Any help would be greatly appreciated. : pray2: Thank you in advance.

[CreganTur]

I don't think you realize how involved this request really is. You're going to need a lot more data than what you have listed... like the locations for every control on the form, table to connect to (if external you'll need connection string data), not to mention any VBA code you want this generated form to use.

What exactly are you hoping to accomplish with this?