KB232592 Help (Basing a drop down based on values from another "DA

[@discussions.microsoft.com Dave]

I've been trying to get this to work, here is my senerio. I've got three
tables. One is a Top Level Failure Codes table(TLDefects), the next is a
Secondary Failure Codes table(SLDefects). I wish to store the input to my
Failure Tracking Table. I want to base my 2nd codes based on the 1st on a
Data Access Page (Recordset:Enter Failure Tracking) Page. I'm confused with
the instructions given in the KB article 232592 which explains how to do it
with the Northwind.mdb. I've recreated that and it works, but trying to put
it in my page fails horrorably. My Unique recordset is the failure tracking
table. Can some one tell me what recordsets to base my drop down boxes on?
I've created two drop downs with the (CodeID) fields being common to both.
Since they are identical it automatically changes one to CodeID1. I've tried
several iterations to accomplish this task, as seen below from my comments in
the onchange event of the ddlTLDefects combo box. Most of the time I get
errors, but some of the time I get blank combo's, or a refreshing of the
other data on the page.

'Orders (SLDefects) is the table on which the secondary dropdown list is
based.
'CustomerID (Code1:Code) is the name of the field common to both dropdown
lists.
'ddlCustomer (ddlTLDefect) is the name of the primary dropdown list.
'MSODSC.RecordsetDefs.Item("SLDefects").ServerFilter = "[CodeID]='" &
ddlTLCodes.value & "'"
MSODSC.RecordsetDefs.Item("Enter Failure Tracking").ServerFilter =
"[CodeID]='" & ddlTLCodes.value & "'"

There is also a problem with the instruction that tells you to add the lines
to the MSODSC.Current object, perhaps this is why nothing seems to work?

'MSODSC.RecordsetDefs.Item("SubAreas").ServerFilter = ""
'MSODSC.RecordsetDefs.Item("SubSubAreas").ServerFilter = ""
This just produces errors.
I'm using Access 2003 with SP2.
Any help would be greatly appreaciated.

[lllllll]

ghfhfghghgfhazhfhzgh
"Dave" <Dave @discussions.microsoft.com> escribió en el mensaje
news:5953758C-DD78-481D...@microsoft.com...