Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    139

    Unanswered: wherecondition...

    I have a form that gets its data from a sql string so-

    strSQL = "select * from account where mnth = 12"

    Me.recordSource = strSQL

    I am opening this form from another with the OpenForm command and I'm trying to apply a wherecondition but it doesn't seem to work. Does the method I'm using for the data source above preclude the ability to use the wherecondition?
    Thanks,
    Bill

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Yes, pretty much.

    That looks like code you would put in the onopen or onload event of the form, why not put that sql string in the actual recordsource?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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