Hi, I'm creating a database for a company and I've been trying for a while to figure out how to get my form to work. Here's the deal....I have very little vb experience and using what little I have, I have run into a problem.
I have a form where I am attempting to match a series of 16 checkboxes (different parts) and a matching set of 16 option boxes (whether or not the parts marked to be sent have actually been dispatched/replaced) which should ONLY be visible when the matching checkbox has a checkmark. For example, when I place a checkmark in the 'Touch Panel' box on my form, a box appears to the right where the end user can mark whether it's been sent/repaired or not (either yes or no).
It works like I want it in the first record, but in any and all subsequent records the option box displays a no, however I only want that option box to be visible if the appropriate checkbox is checked and in this case it is not for the second record so therefore that option box should NOT be visible.
On the attached database on the "Data Entry Form" on the first record, you will see near the bottom on the left side the aforementioned series of 16 checkboxes. You will also see under the "Have any of these been repaired/replaced/sent?" heading to the right of the checkboxes some option boxes, which is where the problem lies. As mentioned, I have little programming experience so forgive my clunky code, but so far I have managed yet I cannot figure this particular problem out.
Hopefully you guys can figure this out. Thanks in advance.
http://www.filehosting.org/file/details/67009/dbase.mdb
I have a form where I am attempting to match a series of 16 checkboxes (different parts) and a matching set of 16 option boxes (whether or not the parts marked to be sent have actually been dispatched/replaced) which should ONLY be visible when the matching checkbox has a checkmark. For example, when I place a checkmark in the 'Touch Panel' box on my form, a box appears to the right where the end user can mark whether it's been sent/repaired or not (either yes or no).
It works like I want it in the first record, but in any and all subsequent records the option box displays a no, however I only want that option box to be visible if the appropriate checkbox is checked and in this case it is not for the second record so therefore that option box should NOT be visible.
On the attached database on the "Data Entry Form" on the first record, you will see near the bottom on the left side the aforementioned series of 16 checkboxes. You will also see under the "Have any of these been repaired/replaced/sent?" heading to the right of the checkboxes some option boxes, which is where the problem lies. As mentioned, I have little programming experience so forgive my clunky code, but so far I have managed yet I cannot figure this particular problem out.
Hopefully you guys can figure this out. Thanks in advance.
http://www.filehosting.org/file/details/67009/dbase.mdb
