Cascading Combo Box - Assistance

[JPW]

Hello

I have a database (Access 2007) that has two tables, reports, queries and so far all seems to be working and going well. Quite impressed with it to be honest for my lack of skills.

However, I've run into a bit of trouble and need assistance getting a combo box to work with another combo box to produce list kind of thing.

The database is a vehicle database and I need the 'Vehicle' combo box to give me a list of vehicles. I then need the 'Model' combo box to produce the models of the car selected in the 'Vehicle' combo box.

Example - If I select 'Ford' from the 'Vehicle' combo box list I want all the models to be displayed in a list form thing in the 'Model' combo box so the user can easily select make and model of the car.

I have two tables:
CarMM
VD

The 'CarMM' table contains a list of around 1,500 records of car makes and models. First column has the 'Vehicle' make and the second field coloumn has the 'Model'.

The 'VD' table contains all other information like the charges, name, the make and model of car once selected in combo box.

I then have the form called 'VD'. In this form contains the combo boxes I want to be cascading.

Any advice on how to do this? I'm quite new to this so any help would be nice. Thanks you very much.

 

[ajetrumpet]

Resource:

http://www.access-programmers.co.uk/forums/showthread.php?p=637091#post637091

It will take some time to figure out how the cascades were done if you download the file, but it is well worth it. You have to be willing to take the time to learn it though.

 

[Varun]

Error Message Thrown

Resource:

http://www.access-programmers.co.uk/forums/showthread.php?p=637091#post637091

It will take some time to figure out how the cascades were done if you download the file, but it is well worth it. You have to be willing to take the time to learn it though.

Hi ajetrumpet,

It is interesting that you mention that there might be a problem with the query (specially when working with only one table)..This is what I am facin.

I have 2 comboboxes linked with each other (FieldCombo is dependant on the value of TableCombo)

The RowSource of FieldCombo reads something like this

"Select t_fields from MasterList where t_name ='" & Me.TableCombo &"'"

The AfterUpdate() of TableCombo reads
FieldCombo.Requery

If I run this, I get an error as follows:

'The record Source ' ~sq_cMainForm~sq_cFieldCombo' specified on this form or report does not exist'

I dont know what is it that I am doing wrong