I have never experienced that behaviour with a form bound to a table/query.If you have a relationship, and your form/subform was created by the Wizard, moving to the subform, will not Automatically save the New record of the Parent form.
If you feel it would be more aesthetically pleasing to your users you could leave the validation code in the form's BeforeUpdate event and have a button labeled "Save" which could be coded to move to a new record which I assume would be the next thing they would want to do and that record movement would cause Access to save the record and fire the validation code........ I always found that if i didn't include a save button, people would always ask for one. ........
Is the confirmation message really required and if so, when. Just after the first items or just when the order is completedOk i took the code off of the parent form and just used the subform code. It's working better now but when i try to select more than one item from the subform menu, the 'Booking Confirmed' message keeps popping up after every choice i make. Sorry if i've done something silly !
bob......of course i missed you all . You guys have dug me out of more holes than i care to remember
Once you move the focus to the sub form the main form record is saved by Access. You could delete the record though, or perhaps better would be to add "cancelled" field to the orders table.They both actually work well. Last thing (i know women are never happy)......if the booking is cancelled can i prevent the record from being saved in tbl_Orders. I could probably work around it but is there a line of code which would achieve the same result ?
I'm really sorry i completely missed your post. Thank you for the suggestionJust my penny.... Isn't it much easier to have all choices in a single (unbound)form? Like use a non-visible combo / listbox that becomes visible after the timecheck? I think this is a very complicated way to get a result.
Thank you for your kind words. There'll always be someone here to help you if you need itGood suggestions thanks a lot guys. I'll work something out.....it's not a major issue anyway. Thanks again for all the help i appreciate it very much
bob.......your Access abilities are surpassed only by your modesty