Form from Options--> All commands vs VBA form

[lezawang]

Hi
I just found that I can create a table then Ctrl+T then I can go to Options-->All commands-->Form and use that command to create a data entry form. My question, what is the advantage/disadvantage of that form compare to a one that I can create using VBA? Thank you very much.

 

[Michael M]

The "automatic" is quicker / simpler to create, but the order of input is fixed. So it basically is in the column order of input
Whereas a form created by you can input the data in any order....and can also include any other features that you want to add, like formulas for a particular column once other data is entered.