Combo Boxes - Form Design

Resolved · Medium Priority · Version 2003

Mon 19 Oct 2009, 10:28 Delegate Heather said...

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.

Tue 20 Oct 2009, 09:03 Trainer Stephen said...

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

Wed 21 Oct 2009, 09:47 Delegate Heather said...

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.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Action queries

Unlike select queries you cannot use action queries as a data source for the use with forms or reports,as they do not return a dataset that can be read.

View all Access hints and tips