DRIVING ME MAD !!!! - PLEASE Help

[PhilipEwen]

I have 2 tables
Table 1: Manufacturers
on this I have ManufID and ManufacturerName fields
Table 2: Products
on this i have ManufacturerID ( Related 1-many, only include records where both match ) which relates to Manufacturers.MaunifID and ProductName, ProductID, Product Description.

What I am trying to do is to create a form which has a combobox at the top which allows you to select a ManufacturerName. Once this is selected a list box beneath is filled with the ProductNames that are relevant to that particular Manufacturer.
Thereby if you were then to change the combobox, the list of products would change accordingly.

I have spend 4-6 hours on this. IT IS DRIVING ME MAD !!
I am so confused now that i would really appreciate it if someone could explain step-by-step the whole process. I haven't even built the form yet ( i don;t even know if i would be better off using a form/subform approach -- I'm so confused now ! )
Please help

 

[Robert Saye]

Phillip I didn't make myself clear, so I remembered a free db download on MS that gives dozens of example forms. Here is the link. The form syncronizing combo boxes is what you want.

http://download.microsoft.com/download/access2000/Sample/2000/W9X2KMe/EN-US/FrmSmp00.exe

 

[PhilipEwen]

Robert & Pat,
Thanks for your help on this. Basically I did understand Robert's advice, but it still didn't work.
I therefore thought i would rethread as people tend to pick up new threads and leave the ones that have been answered.
I had spend hours and hours and by the time i had posted the last thread it was 2am.
I hoped that if i explained it better then someone would be able to point me to an example - Which Robert kindly did !
It was good to get up the following day and have an answer - apologies for those whom i've their time.
Thanks for your help though.