DUPLICATES WITHIN A SUBFORM

Discussion in 'Microsoft Access VBA Modules' started by Songoku, Mar 28, 2008.

  1. Songoku

    Songoku Guest

    Hi

    I Have a Main form which contains semployee data and a PK for clock number
    on this form I also have a linked subform via the Clock Number. The subform
    contains a list of training which a particular employee has done.

    now the problem...

    Currently you can enter duplicate training...is there some code I can use so
    that when a user selects the training it checks the training title and clock
    number to see if it already exists for that user. If it does a message box is
    displayed and the record highlighted if not nothing happens

    Thnxs in advance.....
     
    Songoku, Mar 28, 2008
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. tag

    copy data from one subform to another subform with recordset

    tag, Sep 16, 2003, in forum: Microsoft Access VBA Modules
    Replies:
    0
    Views:
    613
  2. Danny
    Replies:
    2
    Views:
    809
    Tim Ferguson
    Oct 20, 2003
  3. Todd Lemen

    Automate repositioning subform within parent frame

    Todd Lemen, Jun 6, 2004, in forum: Microsoft Access VBA Modules
    Replies:
    0
    Views:
    239
    Todd Lemen
    Jun 6, 2004
  4. Kat

    Referencing control in subform from subform's subform

    Kat, Jun 15, 2006, in forum: Microsoft Access VBA Modules
    Replies:
    5
    Views:
    707
  5. Guest

    Subform not working within single form

    Guest, Sep 13, 2007, in forum: Microsoft Access VBA Modules
    Replies:
    1
    Views:
    171
    Guest
    Sep 13, 2007
  6. Rose B

    Using records selected within a subform

    Rose B, Jul 8, 2008, in forum: Microsoft Access VBA Modules
    Replies:
    10
    Views:
    540
    ranchodondo
    Oct 27, 2008
  7. Noemi

    Help with Child Master on Subform within Subform

    Noemi, Feb 3, 2009, in forum: Microsoft Access VBA Modules
    Replies:
    4
    Views:
    282
    Gina Whipp
    Feb 3, 2009
  8. Noemi

    link subform within subform

    Noemi, Feb 4, 2009, in forum: Microsoft Access VBA Modules
    Replies:
    0
    Views:
    202
    Noemi
    Feb 4, 2009
Loading...