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