limit contents of subform based on shift from table (1 Viewer)

murray83

Games Collector
Local time
Today, 13:14
Joined
Mar 31, 2017
Messages
728
Hi

have tried searching for an answer to this quandary but all i find is how to limit it to n number of records

what i would like to do is as follows

we have 3 shifts all data stored in one table and then 3 subforms but at the moment it shows in each one all shifts, i would like to be able to put a filter on or some such so AM is shown in AM sub form and so on

any ideas/help

cheers all
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 21:14
Joined
May 7, 2009
Messages
19,169
For subform (shift 1), change the RecordSource to:

Select * from yourTable where Shift=1;

2nd & 3rd subform, do the same except change the Shift number accordingly.

'****
Note replace Shift and yourTable with correct field and table name.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 21:14
Joined
May 7, 2009
Messages
19,169
For subform (shift 1), change the RecordSource to:

Select * from yourTable where Shift=1;

2nd & 3rd subform, do the same except change the Shift number accordingly.

'****
Note replace Shift and yourTable with correct field and table name.
 

Users who are viewing this thread

Top Bottom