Automatic filling of DBCombos & DBlists

[Aristarco]

I'm trying to find out how can I fill a <i>DBCombo</i> with the data in an Access Table when I select an Item in another DBCombo that was prefilled with another Access Table. I have a combo called <b>Program</b>. Let's say I choose <FONT FACE=monospace>Telephony</font>, the second <i>DBCombo</i> called <b>SubPrograms</b> should only contain <FONT FACE=monospace>Repair, Installation, Construction</font>. Then if I change my mind and choose the <FONT FACE=monospace>Museum</font> Program, the SubPrograms Combo should only contain <FONT FACE=monospace>Restoration, Rescue, Funding</font>. And So On.<br>The Programs have an ID number in a Table called programs. The Subprograms in the subprograms table have the ID number of the program they belong to. I've tried to make an SQL string in the <b>Change</b> and <b>LostFocus</b> events to update the second combo but not to avail. <font color=red>Can you help?</font> I need to show a prototype next monday!!!

 

[NickBulka]

the onchange event is where you'd change your recordsource. <p>nick bulka<br><a href=mailto: > </a><br><a href= > </a><br>

 

[Aristarco]

Thanks Nick! But I've found that the problem appeared because I didn't use the adcmdType=adcmdText instruction. When I wrote this, the SQL string worked properly.