Hi, I'm currently using access 2007. I've developed a form with a drop down list of different venues and a checkbox on my table of each venue that is available for a New Year's eve event. Is it possible to display a messagebox based on the drop down selection and checkbox being ticked or unticked displaying a message - "Venue will be available" or "Venue will not be available" on my form? Also, is it possible to hide the checkbox selection on the form? Is this possible using vba? If so, do you have any examples of code how this can be done? I've read a few vba books and searched websites but haven't seen as yet any ideas how to do this...I am a novice/intermediate user of vba...


Thanks for your contributions