Heather has attended:
Access Intermediate course
Access Advanced course
Excel Advanced course
Access Advanced course
Combo Boxes - Form Design
I used Access in 1999 but the database was already designed when I moved into the role. I now want to create a control that was on that database which was a combo box with a list of events and then alongside each event in the drop down list there was a series of check boxes for Invited, Accepted, Declined, Attended, No Show. I attended an excellent course on Friday but this was covered. Does anyone know how to do this? Any help gratefully received here.
RE: Combo Boxes - Form Design
Hi heather
Thank you for your question
Creating the control you require would require the use of visual basic. It is a fairly involved task and is therefore beyond the scope of the forum.
One alternative is to create a small based on a table, where you have a text field for for the event name and a series of yes/no fields for the various questions. Then create a form based on that table were the default view is a datasheet. This will replicate the effect you need.
Regards
Stephen
RE: Combo Boxes - Form Design
Hi Stephen, have done the above and it works wonderfully and does create the effect I want except that I have dropped the form into my main database form thereby creating a sort of sub-form. However, whatever choices I select in the sub form are affecting all the records in the main form. I know this is something really simple and have corrected it before in single forms but don't know the answer in form/sub-form work. I definitely need to come on your advanced course and will speak to my Director of Ops about this.
Any help gratefully received in the meantime.
