Search results

Hi I've been using Access for 15 years initially as a data user and latterly as a developer. I'm also a SQL Server developer. Looking forward to picking up new skills from learning how others approach problems/queries

If Dount("CHI", "Table1", "[CHI] = Forms!Form1.txtCHI") > 0 then Msgbox "Error - that CHI value is already in Table1" End if The above is a very simple way to check - you'd need to replace Table1, CHI, Form1 and txtCHI with the relevant values though.