D
Dave Bassett
I have a form with a combo box and several text boxes. I have the visible
property of the textboxes set to false because I want to populate them with
data based on the customer name that is chosen from the combo box. However
when a customer is chosen from the combo box I get the 2115 Error. Here is a
sample of my code:
dim strCustomer as String
dim strBillingAddress as String
dim strCity as String
strCustomer = cboCustomer.Value
if strCustomer = rsRecs.Fields(1) then
strBillingAddress = rsRecs.Fields(2)
strCity = rsRecs.Fields(3)
End If
(1)txtBillingAddress.Visible = True
(2)txtBillingAddress.SetFocus
(3)txtBillingAddress.Text = strBillingAddress
(4)txtCity.Visible = True
(5)txtCity.SetFocus
(6)txtCity.Text = strCity
The error comes on line 3. It does fill in the text box but stops at that
point.
TIA
Dave
property of the textboxes set to false because I want to populate them with
data based on the customer name that is chosen from the combo box. However
when a customer is chosen from the combo box I get the 2115 Error. Here is a
sample of my code:
dim strCustomer as String
dim strBillingAddress as String
dim strCity as String
strCustomer = cboCustomer.Value
if strCustomer = rsRecs.Fields(1) then
strBillingAddress = rsRecs.Fields(2)
strCity = rsRecs.Fields(3)
End If
(1)txtBillingAddress.Visible = True
(2)txtBillingAddress.SetFocus
(3)txtBillingAddress.Text = strBillingAddress
(4)txtCity.Visible = True
(5)txtCity.SetFocus
(6)txtCity.Text = strCity
The error comes on line 3. It does fill in the text box but stops at that
point.
TIA
Dave