Customized a form using a form

[SBBmaster09]

I have this database, and it was always customized every month. Is it possible if Access will customized the form using a form?

The form has a category Order and under Order there are different order names to be checked, is it possible if the user will just add another order name and it will be added on the form.

 

[Frothingslosh]

Before you do anything else, look into normalization. As a general rule, enumerated fields (Order Type 1, Order Type 2, etc) are a giant red flag indicating structural issues. Those fields should almost always be separated out into a different table, and linked to the main table.

For example, instead of an Orders table with order types 1, 2, 3, 4, and 5, you would have an Orders table with a field that links to an Order Types table.