D
den1s
Guest
Hello All,
My DAP has a log-in page which relates to the values 1,2,3,4 or 5. If the user selects 1 then a main menu page appears with the relevent log-in 1 details. I have done this using the server filter script;
<SCRIPT language=vbscript>
<!--
Sub subNextPage (strPage)
Dim strCriteria
Dim strURL
strCriteria = "[Project Title]='" & ProjectTitle.value & "'"
strURL = "../simple-prod/" & strPage & "?ServerFilter=" & _
Chr(34) & strCriteria & Chr(34)
window.parent.location = strURL
End Sub
-->
</SCRIPT>
What i need to do now is also filter the combo box on this page so that only data for log-in 1 only be shown on the drop down. Currently all contacts in the contacts query are appearing irrespective of what log-in is chosen.
So my question is .... How do you filter a combo box in a Data Access Page based on the login value as stated above.
Thanks in advance.
My DAP has a log-in page which relates to the values 1,2,3,4 or 5. If the user selects 1 then a main menu page appears with the relevent log-in 1 details. I have done this using the server filter script;
<SCRIPT language=vbscript>
<!--
Sub subNextPage (strPage)
Dim strCriteria
Dim strURL
strCriteria = "[Project Title]='" & ProjectTitle.value & "'"
strURL = "../simple-prod/" & strPage & "?ServerFilter=" & _
Chr(34) & strCriteria & Chr(34)
window.parent.location = strURL
End Sub
-->
</SCRIPT>
What i need to do now is also filter the combo box on this page so that only data for log-in 1 only be shown on the drop down. Currently all contacts in the contacts query are appearing irrespective of what log-in is chosen.
So my question is .... How do you filter a combo box in a Data Access Page based on the login value as stated above.
Thanks in advance.