Results 1 to 3 of 3

Thread: how to Check the dup.rec in the entry point

  1. May 14th, 2004, 05:30 AM #1
    muraliambt
    muraliambt is offline

    Thread Starter
    Junior Member
    Join Date
    Mar 2004
    Posts
    28

    how to Check the dup.rec in the entry point

    HI,

    In the form, after entering the value in the text box, how can i check that value for the duplication in the Table.
    bye,
    Mursand
    Reply With Quote Reply With Quote
  2. May 14th, 2004, 07:27 AM #2
    Pasvorto
    Pasvorto is offline
    PowerPoster Pasvorto's Avatar
    Join Date
    Oct 2002
    Location
    Minnesota, USA
    Posts
    2,951
    You could use a SQL statement:

    "SELECT * FROM tablename WHERE fieldname = " & datayouarechecking

    Then check for not BOF and not EOF
    Reply With Quote Reply With Quote
  3. May 14th, 2004, 07:51 AM #3
    muraliambt
    muraliambt is offline

    Thread Starter
    Junior Member
    Join Date
    Mar 2004
    Posts
    28
    Thanks man,

    tell me which is the best even to put the checking
    LostFocus or Validate event.
    Last edited by muraliambt; May 14th, 2004 at 07:55 AM.
    bye,
    Mursand
    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