Im having dificulties with the form that i've created
In the Age Band (grouped area) I have 4 Option buttons
Under 18, 18-64, 65-74, 75+
When one of these is selected, I wanted the selected value to appear in cell A100. When I select one of the option button cell A100 only shows TRUE or FALSE, how can i get cell A100 to display the age band selected.
I am also having the same issue with the Ethnic Origin group of option buttons
And also with the FACS eligibility Criteria grouped set of buttons.
Could somebody please let me know what im doing wrong, and how to correct this.
The other thing that I need help getting to work correctly is with the "Click Here to Save this record" command button. I wanted this button to do the following;
When the inputter has completed inputting the details onto the form, the responses that have been input should appear across the various columns of ROW 100. When the command button is pressed i wanted it to;
Move everything in ROW100 (A:L) and below, down one ROW, and then clear the form and finally save the worksheet.
I hope I have explained this clearly,
I tried to upload my .xls file but its too large at 100k, so i have cut out much of the file so that you can at least see some of what ive done, i am more than happy to e-mail a copy of the un-edited version to anyone who could help me with this.
my email address is: [email protected]
Thanks in advance for your time/effort.
I have edited the post to included a zipped attachment (i still had to remove some things from it to get it under the maximum file size.