Hi all, I am making a form to fill in what customers ask for, and the data will go to the tables.
There are a few types of products the customers can ask for, for instances the STC18 and STC24. What I would like to do is to allow the fill-in of the Height and Width of STC 18/24 only when the corresponding check boxes (Need STC18 & Need STC24) are/is checked. Like when the customer does not need STC24, I don't want the form to let users fill in the Height and Width of STC24. So, I am looking for a way to unhide/enable the labels and boxes after checking the check boxes. I think it would require after-update-event and most likely VBA codes which I barely have knowledge on them both.
On the right of the picture is the query I used to merge the two tables and source this form from. I tried typing 'Need18=Yes' under "Criteria" of "STC18_H" and "STC18_W", but it didnt work as intended. Instead, it gives me an error in the form design page.
Any idea is really appreciated and welcome! Thanks for the help!