Yep. That's the video that should help you with your problem. If you mark products inactive and hide them from your combo boxes, that will NOT take them out of the previous orders. You got it.

Hello Richard just to confirm if I have a field in the product table called discontinued which is a yes snowfield to hide the discontinued products I would use yes or true to stop them showing I know this may sound airy basic to you but I'm a person who is a person who needs to get it straight in their head before doing something using my scenario such as products thank you again enjoying all your tech help videos as soon I see where the new video if I have the time or when I get the time I soon jump onto your tech help video to look at the latest video and I also download them quite often from YouTube and store them in a folder called tech help inside a folder which has the lessons that I have purchased from you thanks again for your support you are wonder how you keep helping so many people

Michelle

PS after you have confirmed this I will notify you after I have got the database is running this method now thanks again for all your support and I am sure I am not the only person who would like to say that to you as there are so many people who are not able to become a member the Costner financial reasons really appreciate your work like me it sounds like is more than a job to you you get pleasure from showing people how to do things like I get pleasure helping people recover their lost memories off the old VHS tapes

Hello Richard

I have followed your video do not delete soft delete mark as discontinued is there a way of not showing things in combo without putting a checkmark on like in your video is there a way of changing this to run and rectally from the query which I have called discontinued and where do I set this is this set under source or row source the query that I crated works perfectly but just getting at to the combo's is my problem without having to put a tick on the form

Richard this is just the update I didn't say in that it previous message that I have the two combo is unbound set up as taught in developers six Michelle

Yep. You understand it exactly. Practice with it in a different database first.

You need a YES/NO value to determine whether or not a particular product is available or discontinued. Whether you use a checkbox or not on the form is up to you. Then, you can make a query based on that field to ONLY show available products. Use that query to create your combo boxes.