In our database a Lead = 0, whereas a Prospect = 1. I'm trying to make a drop-down where the users can select whether they are searching for a Lead or a Prospect and have it filter out the results.
Will I be formulating some sort of "If, Then" statement?
If "LeadOrProspect" = 0 Then
LeadOrProspect = Lead
Else
LeadOrProspect = Prospect
End If
Would something like that work?
What I have tried:
I've tried mimicking the status drop-down, however, I find that it's not working.
I've also tried using a "getLeadOrProspect" list, but I think that might be useless.
Here is the code that works right now, I'm just trying to find out how I can incorporate a "Lead or Prospect" drop-down.
<td><select size="1" name="OpenClosed" class="small"><option value="0" <%If OpenClosed = 0 Then rw " selected"%>>Open</option><option value="1" <%If OpenClosed = 1 Then rw " selected"%>>Closed</option></td>
<td><input name="name" value="<%=Request("name")%>" class="medium" placeholder="Business Unit or Group Name" /></td>
<td><input name="phone1" value="<%=Request("phone1")%>" class="medium" placeholder="Phone Number" /></td>