I've got a form based on a table. Just part of this form is made up of 8 yes/no fields which can be split up into 2 groups as below and 8 date boxes. Each record looks like below:
License Number
Activity 1 Y/N Date Confirmed Y/N Date
Activity 2 Y/N Date...
I have a series of tick boxes each representing Y or N. I need to have a further option for R (Revoked) so that I now have 3 options to choose from. Any suggestions on how I go about doing this
Thanks in advance
David, thanks very much for your willingness. I think I can get by on the code (thanks to help from this board). Unfortunately, I'm working on someone elses database and it relies on macros. I'll have another look.
Cheers again
i've got a macro that does this:
When I deselect a tick box another box with the date appears and I enter the date.
When I select the tick box and then select it again so there is no tick there the date has disappeared.
What I want to happen is for the date to still be there when I take the...
I've a form. On this form I want to place a yes/no field with a default to yes (with a tick). When I deselect that tick I want a subsequent text box to appear. Any ideas?
To put it into context the yes/no field that is set to yes refers to whether the company has a licence. When the box is...