Tue 23 Mar 2010, 15:18Delegate Daiga said...
Daiga has attended:
Access Intermediate course
Form validation
One of the fields on my form are combined from two field dat (filed year YYYY and field called code - 0000). This new field contains both values and is automatically generated when both fields are filled by inputer. I need to make sure this new combined field is unique and there will be no duplicates. Let's say only one code per year. How to set up the validation rule? Is it possible in expression builder?
Thu 25 Mar 2010, 16:44Trainer Anthony said...
RE: form validation
Hi Daiga, thanks for your query. That is certainly possible, although the process is rather long to post on this forum. However, try this weblink. It details the procedure you need:
http://www.ehow.com/how_13623_prevent-duplicate-values.html
Hope this helps,
Anthony
