Spreadsheet Input

[jimc52]

I work for a food company where we design new food products. I have an Access Database where I keep track of all the ingredents we use in the company, and add new ones daily.

What I want to do is create a spreadsheet view where I can enter an ingredient inventory code into one field and then have it pull in from my ingredients table information about that ingredient, such as the ingredient description. I need the spreadsheet capability, because I want to design this to be a formulary (recipe) builder. I enter the inventory code and it pulls in the product description and whether or not it is a wet or dry ingredient. This is important because of the kind of measure you use (either weight ounces or fluid ounces, for example).
In the next field, I enter in the formula amount and the unit of measure.
The spreadsheet then calculates the batch amount and total weight of each ingredient (whether wet or dry, in pounds).

When I am done with the formula, I want to save the formula to a table and give it a unique formula number. I also want to be able to make a copy or template of it and use this to make a new or modified formula.

I want to do this using an Access Form(s) and not create an HTML type document view. Does anyone have a clue as to how I could create a spreadsheet view in an Access Form?

Thanks

[NeoPa]

When you say a 'spreadsheet view' do you mean in tabular format with a grid of rows (records) and columns (fields)?
If so, you can have a form designed that way. It would need to have the 'Default View' property set to 'Continuous Forms'.
Also, you'd have to add all the fields you wanted from those in the Recordset source.
The wizard should help you do this.