Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Access Training and help » Combo Boxes - Form Design
|
|
|
Bookmark this page|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Combo Boxes - Form Design
Resolved · Medium Priority · Version 2003
Reply
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.For upcoming training course dates see: Pricing & availability
RE: Combo Boxes - Form Design
Hi heatherThank 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.
|
 |
|
» Forum post: Filling or copy down |
Why do the triangles that appeared in the top left hand corner of the trainer's screen, not appear in mine when I copied down using an absolute formula?
