Data Access Page - Filter Combo box

  • Thread starter Thread starter den1s
  • Start date Start date
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.
 

Users who are viewing this thread

Back
Top Bottom