Cascading DDL, Inside DetailsView, using MS Access and VB.NET/ASP.NET new records
Posted on 2010-11-11
Very specific question - please read.
I have a DetailsView Control on my ASP.NET Page (VB NOT C#)
On my Form I have 2 drop down lists. DDL1 and DDL2 that come from 2 lookup tables that are not part of the main table. DDL2 cascades from DDL1. The Main table has 2 fields, DDL_fk1 and DDL_fk2 that take integer values from the DDLs on the form.
Using MSAccess for backend.
I have functioning cascading code and am able to load the values in the 2 DDLs just fine.
My problem is that if the record does not currently have values in the underlying fields, it throws an error. In other words, if there has NOT been a selection made for either DDL, they should load with DDL1 stating "Please Make a Selection" and DDL2 being disabled.
Instead, I get an error.
Please provide WORKING syntax and code examples.