Using a 'table' in a form (MS Access)

[MulLa]

Hi

First of all I have to say that I'm only a newbie in Access so any reference material to any solutions you provide would be great.

Now here's my question.

I am trying to make a form to enter say 'Stock on Hand', 'Stock Ordered' and 'Qty Delivered' on a month to month basis. I wanted the form to have a whole list of products on it running vertically down the form (something looking like an MS Word table) and the 'stock on hand', 'stock ordered' and 'qty delivered' horizontally across the form. I need to have them all listed at once. Like if I wanted to made 'qty delivered' adjustments for December to 10 stocked items I just need to enter it on this same form once.

On occassion I would need to change to the stocked items list to made additions / removals. If I keep the list of product on a seperate table, is it possiable to made additions / removals of stocked items and the form will automatically adjust itself accordingly?

It's hard to describe what I wanted in words but if you need any clarifications please ask. I have a feeling that to do what I need it would be out of my novice skills I've read the book "Teach yourself Access in 21 days" but it doesn't give me any pointers to what I need to do. Is there any books that you all would recommend?

Thanks in advance for any assistance!

 

[BFG10K]

All you need is a standard continous form based on your stock table and it'll do exactly what you want.

 

[MulLa]

Thanks BFG10K for the tip, sorry for the late 'thanks'.

However I do have another newbie question. I am trying to create a form with sub-form according to what you've said. Or even just a normal form. How do I get it to list out all stock items in one screen? Say I have 10 stocked items in a table called Stock. If I create a form for it, it just gives me one 'entry' at a time with 10 entries that I have to scroll through.


Thanks again in advance.