I have a text box on a data entry form (which is associated with the Dam table) called DamID. I want to make sure that the ID text that someone enters in this text box is not the same as a BarrierID already in the Barrier table. Any suggestions on how to do this? Thanks.

Use DLookup to see if the ID exists. If it does then warn the user to select another ID.