sm007hie
07-18-2005, 06:17 PM
More accurately, I'm trying to figure out how to change specific field values based upon what is selected from a combo box. I can do it for an entire page with this code:
<SCRIPT language=vbscript event=onchange for=cboPoNo>
<!--
Dim rs
set rs = MSODSC.DefaultRecordset
rs.find "[PONO] = '" & document.all.item("cboPoNo").value & "'", 0, 1, 1
-->
</SCRIPT>
But I'm wanting 8 fields to change dependent upon a selection in a vendor combo box. So for instance, if the user selects Home Depot from the list, the following 8 fields (address, phone, contact, etc) will automatically fill in for that vendor. Any suggestions?
<SCRIPT language=vbscript event=onchange for=cboPoNo>
<!--
Dim rs
set rs = MSODSC.DefaultRecordset
rs.find "[PONO] = '" & document.all.item("cboPoNo").value & "'", 0, 1, 1
-->
</SCRIPT>
But I'm wanting 8 fields to change dependent upon a selection in a vendor combo box. So for instance, if the user selects Home Depot from the list, the following 8 fields (address, phone, contact, etc) will automatically fill in for that vendor. Any suggestions?