I have a form that is used for data entry and I noticed a problem with information not getting on certain reports that I need because of a validation problem, we have codes for all of our locations and within these locations we have codes for the represenative of that location and my queries and reports are based on those codes, but what I am finding is that data entry is not entering the right represenative code and some people aren't getting on the right reports, is there a way I can set it so that when you enter a certain location you can only enter a certain code for that location? example: city1 is code 05 and within city code 05 you can only enter a 01 or 02 for represenative? Please help this is a big problem!