Combo Box to Return Records In 2nd Combo Box!

[BlankReg]

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.

 

[namliam]

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

If you get stuck, post back here.

 

[BlankReg]

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

 

[namliam]

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

 

[BlankReg]

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

 

[namliam]

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.

 

[BlankReg]

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

 

[namliam]

If you try a search 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.

 

[BlankReg]

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

 

[namliam]

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