Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    74

    Unanswered: check for empty records

    hi,

    i have a search function where i used me.recordsource ("SELECT ........") and using me.requery to display the fields based on the search criteria.

    how do i check if there are no records at all under the criteria given by the user? in other words, how do i check if my sql statement did or did not retrieve any records??

    pls advice
    nono

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    RecordCount Property

Posting Permissions

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