[Resolved] - Another beginners question

I have a subdatasheet on a form. The subdatasheet is named sfmLog and the form it refers to is name frmLog. Is it possible to filter this subdatasheet using VB using something like

sfmLog.recordsource="SELECT * FROM tblLog WHERE [Date]=#09-Aug-04#"
sfm.Requery

I have tried several permutations of this without success and have been unable to find any other posts on the subject

Thanks

Remember that he heiarchy goes Forms![frmLog]![sfrmLog]!
[Date].Value or something to that effect.

Thank you again