Show a checkbox for "no"

SueBK

Registered User.
Local time
Tomorrow, 07:42
Joined
Apr 2, 2009
Messages
197
I am reproducing a report originally designed to be manually completed in Word. The client wants it be an 'exact' replication. On the original form I have a table with three columns - the item to be considered, a 'yes it applies' column (checkbox), and 'no, it doesn't apply' column (checkbox). The user check either yes or no. (see below)
In my database table design I have simply set the field for each of the items to be considered to yes/no. However, this only gives me a single checkbox - marked for yes, unmarked for no.
How can I use this field to re-create the separate yes/no checkboxes on my report?

Current Word format:
Issue Applies
Issue abc [] yes [x] no
Issue xyz [x] yes [] no
Issue 123 [] yes [x] no
 
Presumably the informant could check neither answer, therefore you could need two separate checkboxes. Having separate boxes for yes and no on the same question is only a breach of normalization if the answers are truly the inverse of each other.

If that really is the case then use one bound and one unbound checkbox.
In the AfterUpdate Event Procedure of each checkbox enter something like this:
Code:
Me.othercheckboxname = Not Me.thischeckboxname
 

Users who are viewing this thread

Back
Top Bottom