Product Formulation Entry Form Clean Up

[Kozbot]

Hello,

I am attempting to make a product formulation database for my company. The current formulations are stored in word docs in the format attached.

I am attempting to make a clean and user friendly entry form to enter in the product formulation data. Attached is what I have so far. You can see how this form could get awkward and hard to use. Each product can have up to 10 ingredients and 4 or 5 options for each ingredient.

My question is: how do I make my form look as much like our current formulation sheet as possible? or is there a better more "clean" way to design this form?

Thank you!

 

[isladogs]

Recommend you don't use subdatsheets.
As you say these will be very confusing to users.

Replace with one or more subforms providing extra detail at each level.
The subforms are often done as datasheets but you can also use continuous or single forms

 

[Minty]

Rather than sub datasheets try using multiple continuous subforms . They can be made to look much tidier and "professional".

 

[Kozbot]

But can I nest continuous forms within each other?

 

[isladogs]

Yes you can. For example in the footer section

 

[Kozbot]

Yes you can. For example in the footer section

When I try to drop in a continuous subform into the footer section of a continuous form I get "You cannot do this"

 

[Minty]

Yes, and you can ignore that and set the form back to continuous.
It's an undocumented Access "feature"