Sub Form To Show All Records

[wizcow]

Hi

I have a Form, 'StockTake'
It has 3 fields, 'Date' , 'Employee' and 'StockTakeID'
(when a stock take is done it is to tell us when and by whom)

Imbeded on the Form is a Sub Form, 'StockTakeSub'
The Sub Form is set to 'Data Sheet'
It has several Rows to show the stock data.
('StockNo' , 'Description' , 'HowManyInStock' etc.)

The Form and Sub Form are Related by thier 'StockTakeID' numbers.



What I am trying to accomplish is to have the Sub Form display every stock item, when a new stock take is started.
The user then simply has to enter a value in 'HowManyInStock'
(I'm trying to keep the user from having to enter the 'StockNo' for every part.)

How do I get my Sub Form to do this?

Tom

 

[hermanlaksko]

Looks like you need to link the main and sub forms.
Look under data on the subform - Link child/master fields.
This should do the trick.

 

[SBendBuckeye]

Tom,

Can you post some data from your current form to help clarify what you are trying to do? It sounds like you want to list everything in the list for a new item only. Is that correct?

Good Luck! Please remember to give helpful posts the stars they deserve! This makes the post more visible to others in need!

 

[wizcow]

hermanlaksko

My master and child fields are linked by the InventoryID fields.

SBendBuckeye

My form is for doing inventory at a parts store.

With the form and subform I have now, the user enters the 'Date' and 'EmployeeNo' on the MainForm, then an autonumber is asigned to the 'StockTakeID' field. This is okay.

They then have to enter thier part number into the 'StockNo' field on the SubForm. Now the user must enter a number into the 'HowManyInStock' field. This is done for every part that they count. The SubForm looks something like this.

------------------------------------------------------
Date EmployeeNo StockTakeID
Oct. 15/02 327 001
------------------------------------------------------
------------------------------------------------------
StockNo HowManyInStock

01-55-102 10
01-55-103 15
01-05-111 27
------------------------------------------------------

I'm trying to make their job easier.
If the user started a new Stock take and the SubForm diplayed all the 'StockNo's, the user would have to only add a value in 'HowManyInStock'

I hope this makes some sense.
Thanks
Tom