Results 1 to 3 of 3

Thread: [Resolved] - Another beginners question

Threaded View

  1. Aug 24th, 2004, 12:54 PM #1
    jrpfinch
    jrpfinch is offline

    Thread Starter
    Member
    Join Date
    Jul 2003
    Posts
    35

    [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
    Last edited by jrpfinch; Aug 25th, 2004 at 02:43 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width