Results 1 to 2 of 2

Thread: [RESOLVED] check record exists when find a record

  1. Mar 22nd, 2006, 01:21 AM #1
    binilmb
    binilmb is offline

    Thread Starter
    Hyperactive Member binilmb's Avatar
    Join Date
    Nov 2005
    Location
    Kochi
    Posts
    472

    Resolved [RESOLVED] check record exists when find a record

    how can i check record exists when find a record using

    Rec.Find "Stno=" & txtStno.Text

    if no record is there how can i check it
    ßįňįl
    Reply With Quote Reply With Quote
  2. Mar 22nd, 2006, 01:24 AM #2
    d3gerald
    d3gerald is offline
    Frenzied Member d3gerald's Avatar
    Join Date
    Jan 2006
    Posts
    1,348

    Re: check record exists when find a record

    try this
    VB Code:
    1. Rec.Find "Stno = " & txtStno.Text

    2. if not Rec.EOF then

    3.     'the record exists

    4. Else

    5.     'the record does not exist

    6. End If
    On error goto Trap

    Trap:
    in case of emergency, drop the case...
    ****************************************
    If this post has been resolved. Please mark it as "Resolved" by going through the "Thread Tools" above and clicking on the "Mark Thread Resolved " option.     if a post is helpful to you, Please Rate it by clicking on the Rate link right below the avatar
    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