checking for the existence of a record in a spreadsheet from a user form

I have a form (MyForm) for users to input data (two key fields they enter in the form are DATE and LOCATION). Then when they click a MySave button on MyForm, the data they entered in the form is saved to individual columns the next blank row in a spreadsheet.

I want to make sure that they cannot save a record that has the exact same DATE and LOCATION as a record that had already been saved in the spreadsheet.

So I'm looking for some code that I can have on the click event for MySave that first checks the spreadsheet to ensure a record with the same date in the DATE column and the same location in the LOCATION column does not exist. If such a record already exists, then a msgbox appears telling the user that the record already exists.

Maybe a small sample xls file with the correct data layout and your coding ?

Basically, you do not want a duplicate record.

This is a simple workaround needs a little setup but saves a lot of coding. I use a simple method to check for duplicates. Usually, all my workbooks have a calculation sheet, In the calculation sheet, I look up the text box value if an error is returned I proceed to save the file if the lookup returned a value that means there already is a record. So a message is displayed.

If your case I will do the following:
In the calculation sheet, I will have two cells A1, A2. I will store Date in A1 and Location in A2. In b1 and B2, I will write a formula to lookup values in A1 and A2 from the dataset. In B3 I will write an OR function to check if either b1,b2 returns an error that means the combination of date and location does not exist in the database. If none of them returns an error that means the combination exists.

I can share a worksheet with example if this is not clear.