Cascading combo boxes

[astarbyfar]

Just wondering if anyone can help Im creating two combo boxes where the first one determines the values in the second one.

The tables are made up of the following;

Line

Line number (PK)
.....
....

Main Setting

Part Number (PK)
Press Line (FK)

Now ive took the advice of previous threads but im having the following error message when im creating this;

The record source 'SELECT [Main Settings].[Part Number] FROM Main AS Settings WHERE [Main Settings].[Press Line]=[Forms]![Example]![Line]' specified on this form does not exist.

I know that this doesnt exist but im typing it correctly. Access seems to be changing my statement i.e. inserting the AS command. Any help will be much appreciated

 

[blue_wyvern]

cascading comboboxes

An great example of this was posted on the forms forum some time back, I have attached it for you.

blue_wyvern

 

[jrjr]

You state that your table name is Main Setting but the query refers to [Main Settings] (plural)

It would be best to eliminate the space between the words such as this:

MainSettings or
Main_Settings

 

[astarbyfar]

I know the table anmes are not ideal. Im doing a placement for a company where they need the database improving. I will sort this later.

The example was extremely useful and ive been able to sort the problem out. Thanks for the advice