Still kinda new to ACCES. WHat is have is a reservation system.
I have a table with the schedule for the season. When I create the reservation for a person using a form which is updating another table called ResTrip, when they pick the date they want to go, I want to make sure it is in the schedule table
If they pick an non-existent date,, I want a message to appear "Invalid date", otherwise just continue.
It should be a simple IF THEN ELSE but can't figure out how to get a YES/NO answer out of a query so I can do a logic compare. I was hoping to put this in a Macro, still learning VBA
I was thinking using DLOOPKUP, but no joy yet.
Any suggestions?