Repeating cascading drop down with database connection

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

R3 - 12 Apr 2005 12:50 GMT

I'm trying to create a form containing repeating cascading drop down.
I'm using a database connection. The two drop downs are getting populated
from the database. The problem comes when I repeat the cascading drop down.
the second drop down is takes value depends on all the instances of the
first drop down.

How can I solve this problem??Any help???

Reply to this Message

Sumanth Peddi - 12 Apr 2005 22:55 GMT

When you create a data connection for the second drop down make sure to
uncheck the check box automatically retrieve data when form is loaded.
Then in the OnAfterChange event of the first dropdown access the form's
data adapter's and change/filter the query and then submit the query. This
should fill the second drop down based on the value of the first drop down.

Reply to this Message

R3 - 13 Apr 2005 10:50 GMT

Thanks, Sumanth, for the help.

Now the cascading drop downs are working fine.
But a runtime error arise when I try to repeat the table(when I click the
'Insert Item' link of the repeating table).

What I could understand is that the OnAfterChange function is called on the
click of 'Insert Item' link and returning something. I cannot understand
what it is returning.

???

Reply to this Message