Sub Form

[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

 

[dynamictiger]

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

These two statements are mutually exclusive. By relating the subform to the main form on the StockTakeID the subform will display records only for the stockTakeID entered. Yet you state you want your subform to display all records.

Delete the ChildLink property and your subform will display all records.

HTH