Filtering a subform from its Parent in a Access 2002 ADP

[uthomsst]

I have created an access 2002 project (.ADP) with a series of tables stored within MSDE.

I want to create an enquiry form where I can enter some data (ie. date from, to) into fields on the form and have the data appear in the subform below. I would then like to use this data in a report.

I have tried filters which don't work. They only seem to work if I enter static value such as d3cdate = 30/04/2004. As soon as I try d3cdate = Forms![main]![DateFrom] it no longer works.

I have tried altering the recordset by querying the table in code and setting me.recordset = newrecordset

Nothing I do works.

I have searched through this forum and cannot find anything that works.

I am tearing my hair out after doing this for a full week and being no further on.

 

[PHV]

And something like this ?
"d3cdate = #" & Forms![main]![DateFrom] & "#"

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884