I need to populate three combo boxes with data from tblJCA. The table contains text values like 1 or 1.2 or 1.2.3

The first combo box should list all the single digit text figures from the left (in this case "1")

The second combo box should cascade from here listing all the second digit values that apply to the first digit (in this case 1.1 and 1.2 and 1.3 and 1.4 etc...) If the first digit had been a "2" this box would show 2.1 and 2.2 and 2.3 etc... values

The third combo box build on this by listing the three digit values that apply to the second digit. In this example of "2.2" the combo box should list all the three digit values that have the first two of "2.2" such as 2.2.1 and 2.2.2 and 2.2.3 etc....

Not sure how to write the code to populate the control source for the combo boxes, any help available?

Thanks
Dave

Dave,

See if This helps

I still don't see how to cascade based on a previously selected value in a given position in a text string

Dave,

Did you download one of the Demos and look at the tables and code behind the Combo Boxes in the Forms to try and adapt to your needs ? There are many examples and and a great deal of discussion here in the Forum dealing with Cascade/Synchronized combo boxes if you do an advanced search.

Sorry for delay in getting back but I had knee surgery yesterday and now have the laptop fired up

I understand how to write a cascading combo box. What I don't know how to do is write the WHERE claus. For the first combo box it should pick out only pick single digit text values like 1,2,3 out of a text value like 1.5.9

From there how do you write the WHERE claus for the second cbo where I want all the third position values tied to the first one If value 2 selected in cbo1 then cbo should list all 2.x values

Dave,

Sorry to hear about your knee hope everything is OK. I really do not have a solution for you hopefully another member will pick up on this and be able to assist. Only thing that comes to mind is looking at the Left, Right functions Here

I thought about those functions but can not come up with a way to do it

Thanks for the look

Bump

Dave