T
tbotkin
I am trying to filter a combo box on a form using a combo box. The combo box
on the form cboVendorSelect is a bound combo box. The combo box that I am
using as a filter cboVendorName is unbound. Both combo boxes contain two
fields, VendorNo and VendorName and both draw from the same row source. The
first field is the Bound Column in both combo boxes; both are hidden with
only the VendorName showing on the form. All the fields are text.
When I apply the filter I receive and error; Run-time error 2448 Can’t
assign a value to this object.
Here is the code I am using. Any suggestions?
Private Sub cboVendorname_AfterUpdate()
If Me.Dirty Then Me.Dirty = False 'Save first.
Me.Filter = "[VendorNo]"" & Me.cboVendorname& """
Me.FilterOn = True
End Sub
Thanks in advance
Tbotkin
on the form cboVendorSelect is a bound combo box. The combo box that I am
using as a filter cboVendorName is unbound. Both combo boxes contain two
fields, VendorNo and VendorName and both draw from the same row source. The
first field is the Bound Column in both combo boxes; both are hidden with
only the VendorName showing on the form. All the fields are text.
When I apply the filter I receive and error; Run-time error 2448 Can’t
assign a value to this object.
Here is the code I am using. Any suggestions?
Private Sub cboVendorname_AfterUpdate()
If Me.Dirty Then Me.Dirty = False 'Save first.
Me.Filter = "[VendorNo]"" & Me.cboVendorname& """
Me.FilterOn = True
End Sub
Thanks in advance
Tbotkin