PC Review


Reply
Thread Tools Rate Thread

DUPLICATES WITHIN A SUBFORM

 
 
Songoku
Guest
Posts: n/a
 
      28th Mar 2008
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.....
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Link Subform to subform within another subform Sarah Microsoft Access Form Coding 2 1st Mar 2008 02:38 AM
Creating a SubForm within a Subform within a Form MaceagleFL Microsoft Access Forms 1 17th Nov 2005 10:11 PM
Check Duplicates w/o duplicates! Mark Microsoft Access 0 10th Feb 2005 04:39 PM
Change index from No duplicates to duplicates allowed ReidarT Microsoft Access Form Coding 1 4th Jun 2004 04:08 PM
Duplicates/Not duplicates Anna Microsoft Access Queries 2 5th Aug 2003 09:41 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:55 PM.