Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Sep 2008
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Preventing duplicate names (2002)

    I have a field in a form that I am adding names to from a dropdown menu. How can I prevent a name from the dropdown menu form being added twice to the field?
    The name of the field is LNFN

    Thanks.

    Paul

  2. #2
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Preventing duplicate names (2002)

    Set the index on the field to 'No duplicates'.
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

Posting Permissions

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