2115 Error

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top