Function BuildSelectControl(strName, strValue, bAdd)
Set rsTemp = server.CreateObject ("ADODB.Recordset")
strSQL =""
strSize = 1
if IsNull(strValue) then strValue=""
BuildSelectControl = " "
bAddNewItem = false
if "Alternate_Address" = strName then strSize = 1 : strSQL = "SELECT DISTINCT [Alternate_Address], [Alternate_Address] FROM [dbo].[ALTADDRESS] " & " ORDER BY [Alternate_Address]" : strField="Alternate_Address" : bAddNewItem = false : strLookupTable="dbo.ALTADDRESS" : strLinkField="Alternate_Address" : strDisplayField="Alternate_Address" end if
THIS IS OK!
WHAT I WOULD LIKE TO DO IS - :
if "Alternate_Address" = strName then strSize = 1 : strSQL = "SELECT DISTINCT [Alternate_Address], [xxxfield] FROM [dbo].[ALTADDRESS] " & " WHERE "xxxfield= yyyfield " : strField="Alternate_Address" : bAddNewItem = false : strLookupTable="dbo.ALTADDRESS" : strLinkField="Alternate_Address" : strDisplayField="Alternate_Address" end if
IT THIS POSSIBLE!!