Hi All. I'm Sure this is simple enough, but i just cant seem to figure it out.

I want to use a Combo dropdown box with Codes FC000 - FC900. to return records in a second drop down box that begins with the Letters selected in the first dropdown box.

So When a Record is Selected in ComboBox1 eg: (FC0**), ComboBox2 brings up the record to match (FC000).

eg:
ComboBox1: ComboBox2:
FC0** FC000
FC010
FC020

I hope i have expressed what i want to do.

Any Help would be greatly appreciated.

Try and have a search for "Cascading combobox" and see if you can find some examples....

If you get stuck, post back here.

Hi there, thank you for your quick reply. i've found a template on the net, which is exactly what im trying to do. i just dont understand how to put it all together.

maybe you could shed some light. if possible, thanks

Sure possible. Post what you got and your requirements, we can go thru what needs to happen.

Hi again. right ok, so far i have created 2 tables;

Table 1 - Faults
Table 2 - Fault Codes

Table 1 (Faults) contains all the Faults Possible.
Table 2(Fault Codes) contains all the codes that match the faults

eg:
FC0** - User Damage
FC1** - No Fault Found
FC2** - Display Problems

I understand how to create the combo boxes, i just dont understand how i match the two boxes together.

I want if possible a User to Select a Fault from table 1, then Table 2 loads up with it's fault code.

i hope you have understood and thank you for your time

I presume you have some way of linking table1 to table2??

You should make a query that is query-ing table2 with a where to the first combobox.
Then using the "on change" event of the first combobox refresh/requery the second box.
Combobox2.requery will refresh it for you.

Could you give me an example of how you would go about doing this please?

im sorry im a beginner and havnt had much experience. thank you

If you try a search (http://www.access-programmers.co.uk/forums/search.php?searchid=1966670) on "cascading combo" in the samples forum you will find 3 examples right there....

If you have any questions about them I would be happy to answer them for you.

Hi Namliam.

i searched through all the samples, they all seem brillant and definitly what im after.

i downloaded one of the templates, but im literally at the end of my teather, i dont understand what goes where and so on.

maybe you could give me some ideas on how you would go about doing this. thanks

Using the samples you should be able to atleast get started... What problems do you encounter? And/or what do you not understand?