Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Location
    Dallas, TX
    Posts
    77

    Unanswered: what's value if the recordsource has nothing

    If i have one recordsource as:

    Me.recordsource = "select * from table1 where active = 0"

    what there is no row as active = 0. So i select nothing?
    then what's the value of the Me.recordsource?
    thanks a lot

  2. #2
    Join Date
    Jan 2003
    Posts
    81
    Try Debug.Print Me.RecordSource

    The "value" should be: select * from table1 where active = 0

    However the RecordSet.EOF = True
    if no records are found

    Bjorn

Posting Permissions

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