Insert Existing Fields to forms

[jithb4u]

Hy all,
I want to insert existing fields from current table to the form.
I can do it manually in design view...
The field names can vary each time (i did it with import excel spreadsheet method)
But is there any chance to done it with vba code or macro??
Thanks in advance

 

[arnelgp]

you "drag" each fields inside the form.

 

[jithb4u]

you "drag" each fields inside the form.

If a vba code or macro can do this it will be more helpful. Is it possible?

 

[arnelgp]

you don't need macro or vba.
just click on the any table or query.
then on the Ribbon, you click Create->Form.

 

[The_Doc_Man]

If a vba code or macro can do this it will be more helpful. Is it possible?

There is a "wizard" that will build forms for you automatically. Creating it with a VBA module is CERTAINLY possible and CERTAINLY more trouble than it is worth, particularly since there is already a way to do it that does not require additional code.

 

[sxschech]

Maybe this as a starting point?
Search term:
vba to add fields to a form in access

Application.CreateForm method (Access)

Access VBA reference

docs.microsoft.com

Application.CreateControl method (Access)

Access VBA reference

docs.microsoft.com