Rocky Smolin
rockysmolin at bchacc.com
Wed Nov 18 11:33:06 CST 2009
In the before update event of each field check if field1 = field2. If yes, then message to user delete contents of the field being checked. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hollis, Virginia Sent: Wednesday, November 18, 2009 8:47 AM To: accessd at databaseadvisors.com Subject: [AccessD] Duplicates on Two Values Number 3. ItemName can be repeated & so can the ItemDesc just not together in the same record. For example, Paper comes in several different kinds, it can be Legal Paper, Lined Paper, Construction Paper, etc. I just don't want them entering Legal Paper twice. If it has already been entered, I would like it to take them to that record, but at this point just letting them know Legal Paper has been entered would be ok. I am having a problem checking ItemName AND ItemDesc, especially since they are text fields. ItemName: Paper ItemDesc: Legal ItemName: Paper ItemDesc: Lined ItemName: Book ItemDesc: Legal ItemName: Book ItemDesc: Lined ******** Is it the case that you have three checks to make? 1) Is ItemName already being used in an existing record? 2) Is ItemDesc already being used in an existing record? 3) Is ItemName = ItemDesc in the current record? Rocky -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com