3 (depending) dropdowns in DAP

H

Harm Ozinga

i want to have a DAP with 3 dropdownlist where the second is depending on the
first end the third is depending on the first and second.
all the dropdownlists are displaying data from a table

Harm Ozinga
 
S

Sylvain Lafontaine

The easiest way would be to refresh the page in OnChange event for the
combobox after collecting the value in a cookie; for exemple:

<SCRIPT language=vbscript event=onchange for=ComboIdOrganisme>
<!--
SetCookie "IdOrganisme", ComboIdOrganisme.value
window.location.reload()
-->
</SCRIPT>

Of course, you can also use a Submit (instead of cookies) for collecting the
values. The SetCookie is a function that you must write yourself.

Then, when the page refresh, you read these values back and use them as
parameters for the RecordsetDefs used as the sources of your comboboxes by
using Global variables and not local variables (because call to
..parametervalues.Add(...) are being done with ByRef and not ByVal):

Dim GlobalValue ' Good.

Sub MySub
Dim LocalValue ' Not so good: may cause you trouble.

With msodsc.RecordsetDefs ("dbo.MyCombo_StoredProcedure")
.parametervalues.Add "@V1", GlobalValue ' No problem here.
.parametervalues.Add "@V2", LocalValue ' Possibility of a problem
here.
End With

End Sub

See the following page for a full exemple:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/ODC_acc10_DSCOM.asp

There is a newsgroup about DAP; you can use Google to look for previous
posts:
http://groups-beta.google.com/group/microsoft.public.access.dataaccess.pages
 
Top