Msgbox if value exists in table

[Matoco1]

I have an input form called "input" linked to "table1", I would like to have a msgbox appear to tell me if a value exists (name for example), and possibly check a yes/no box automatically to show more than one record exists. But I dont need to see the old record.

 

[HiTechCoach]

Might try using Dcount().

 

[Matoco1]

thanks Ive managed to use DCount as a macro condition, I couldn't work out the code for VBA

I also made the mistake of setting the macro to run after update

Sorted now though

 

[HiTechCoach]

Glad to hear that you got it working!

Good luck with your project ....