Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Cascading Combo boxes

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Cascading Combo boxes

Resolved · Medium Priority · Version 2010

Reply Mon 24 Jan 2011, 11:08Delegate Steve said...

Steve has attended:
Access Introduction course
Access Intermediate course

Cascading Combo boxes

Hi,

I recently studied the introduction & intermediate access 2010 course with microsofttraining.net and at the time it all made sense, however I am trying to put this knowledge into action but am failing somewhere.

What I am trying to achieve is a form whereby there are 2 combo boxes, one that says machinetype, the other that says machinename.

I would like it so that when you select a machinetype, the only machinenames that are available in the second combo box are directly related to the machinetype that was selected on the first combobox. However, I am struggling and cannot get this to work.

I suspect I may be getting the relationship between my two tables wrong but dont know where to start to troubleshoot.

Can someone let me know what I should be checking to try and indentify the problem and its solution.

Thank you.

Steve.

For upcoming training course dates see: Pricing & availability

Reply Thu 27 Jan 2011, 16:21Trainer Simon said...

RE: Cascading Combo boxes

Hi Steve,

Thank you your question.

It probaby would be a good idea to check your table relationships.

However you would need to write a VBA procedure to produce your cascading combo boxes.

Here is a link to some help on this matter.

http://www.fontstuff.com/access/acctut10.htm

I hope this helps.

Regards

Simon

Reply Thu 27 Jan 2011, 16:37Delegate Steve said...

RE: Cascading Combo boxes

It definately was a good idea to check the table relationships. I was relating the table to the wrong column.

I think the moral of the story is to test the work you have carried out before moving on!

Thanks Simon. :)

Access articles

· Guide To Adding A Text Box Form Control In Access 2010
· What Is The Database Documenter And How Is It Used?
· Some Things You May Not Know About Relational Databases
· The Benefits of Certified Microsoft Training in Access
· Why Do I Need To Use Access?

Please browse our web site to find out more about
microsoft access 2002 training and other Microsoft training courses.

Access tip:

How To Find All Overdue Accounts?

To find overdue accounts create a filter that compares today's date with the Invoice Date in the table. To do this:

1. Open the Query in Design View
2. Select the field for the filter and in the criteria row enter:

<Date()

This filter returns records where the Invoice Date is before today's date.

This filter can be manipulated if, for instance, Invoices are due 15 days after the Invoice Date. For this the filter would be:

<Date()-15

This filter returns records where the Invoice Date is 15 days before today's date.

View all Access hints and tips