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.

Share This Page