subform criteria

[MAINOH]

I have subfrmTIMESHEET_EXISTING which currently displays data which matches [employeeid] on the main form frmTIMESHEET.

This is accomplished by setting Link Master Fields = cmbRESOURCE and Link Child Fields = EmployeeID.

I would also like to limit the data displayed to that where [subfrmTIMESHEET_EXISTING]![DAY] falls between [frmTIMESHEET]![POPBEG] and [frmTIMESHEET]![POPEND]

I tried setting the following:
Link Child Fields = EmployeeID;DAY;DAY
Link Master Fields = cmbRESOURCE;>=POPBEG;<=POPEND

But it just ask me for parameter value of >

Any suggestions?

Thanks!

 

[CautionMP]

MAINOH,
You need to filter the subform for the dates you want, then the Link Master/Child relationship should provide the additional filter.

Hope this helps,
CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)

 

[ThomasLafferty]

Hiya Caution!
Filtering is a good short term fix, but can be a bit unstable over the long run. He may want to consider a query and using it as a data source and applying/removing it by means of a command button/option group, etc.

Tom

Born once die twice; born twice die once.