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. Todd Lemen

    Automate repositioning subform within parent frame

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

    Referencing control in subform from subform's subform

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

    Subform not working within single form

    Guest, Sep 13, 2007, in forum: Microsoft Access VBA Modules
    Replies:
    1
    Views:
    140
    Guest
    Sep 13, 2007
  4. Noemi

    Help with Child Master on Subform within Subform

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

    link subform within subform

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

Share This Page