Access 2003

[pdbaker]

I have two tables both with a company ID field in the same numbers in both tables the first table contains also a field with the company name and the second table contains the course title. There is also a form and on that form i want to be able to create a drop down list box showing the courses offered by that particular company that i have that record on. how do i do this
hope someone can help as i have tried using relationships and doing a query but it doesnt seem to be working if it does its duplicating everything

 

[Banana]

Search the forum on cascading comboboxes.

 

[pdbaker]

will it still work

will it still work though the inital box on the form showing the company name is a text box.

 

[Banana]

You need comboboxes; you can convert a textbox into a combobox by right clicking the textbox and select "Change to.... combobox" to accomplish that.

Alternatively you can just create a new combobox with Wizard on to help you get all properties set up right.