I want to Search for a record and if not there Create
Does any one have a script that Looks at a table to find a record and if thge record isn't there it creates on.
I'm trying to Look for a record for a given month and year and if there isn't one it creates one. However I dont want someone (Me) missspelling a month and creating a record when it didn't need to
I used custom messages to get month and year inputs from user and that worked except when I missspelled March it created a new recored for Mrch.
I then tried creating a layout that would behave as a custom dialouge box but it didn't unless i pepper the script with pauses
Now I have a head ache