How to check previous input with validation

Jesse,

Neat Calendar!

Do we assume that guests sharing a room need to be on identical "packages"?
Because neither the Data or Hotel Input worksheets show which room is assigned to a User, or whether they are sharing or single, so the form will not know which guests are sharing a room, and therefore need the same package or not?

Ochimus

Hello Ochimus,
No the purpose of my check is to ensure that the correct hotel has been entered and that subsequent packages in the dropdown list are what they want.
The hotel will allocate the rooms once they receive the completed Keyed in Data sheet from me.
I want to check that they have entered the correct information or are aware that they are entering a different set of data. The warning that comes up in Data Validation also them to cancel or continue.
Any help would be appreciated.
Regards
Jesse

Hello Glen,
I am hoping to arrange a game off season in warmer climes and I can get various packages but I need to know that the person inputting the data is aware if they input data that was not the same as the previous one.
Any mistakes could cost them so I am trying to make sure that whatever is saved in the keyed in page is correct.
Thank you for your interest.
I am enjoying your tutorials as I have tried to solve this problem before troubling anyone.
Regards
Jesse

Jesse,

Is this what you want to achieve:

Hotel Input will be only one record.
1. Make booking:
Record has to be created on the Client worksheet in first place.
Guest enters their Name in Hotel Input, and selects a Hotel. That populates the Code Dependent DropList, and that choice populates the Package DropList. You need to clear the Code and Package cells if the Hotel changes, and clear the Package cell if the Code changes, otherwise they could still show previous options?
User completes form and adds the NEW booking to the next free row on the Client worksheet.

2. Checking an existing booking:
Client enters Name, Hotel and Arrival date, clicks FIND button. That finds the matching booking on the CLIENT worksheet, and lists the details in the Hotel worksheet.
If the details are still correct, they close the query which clears the Worksheet.
If they want to add, delete or change anything they do so, then UPDATE button "overwrites" the original record on the Client Database automatically.

Is that the process?

Ochimus

Hello Ochimus,
Thai is exactly what I am trying to achieve.
My transfer VBA code has the clear contents in it, dormant at the moment, and I wondered if the previous input for the Hotel, Package and length of stay could be checked
to ensure that the person putting in the details didn't click on the wrong hotel, package, or length of stay. But more importantly that the same persons name was not
entered twice. I was going to tweak the Formula/code to include the name.
I think this may well be a VBA code issue? which I still have no idea how to go about it.
Regards
Jesse

Hello Ochimus,
Thank you for the program. It certainly has guided me in achieving my goal.
So much data to absorb and play with. I am going to enjoy this. Will keep you posted on any changes, if there are any, and additions.
Regards
Jesse