P
Pam
I have a customer form in access 2007. I have the "customer name" pulling
from the customer database (of course) but I also want the address, and
shipping address to pull from the database.I have tried this code, but it
errors out at ".Rowsource" with a "method or datamember not found"
Private Sub Customer_AfterUpdate()
On Error Resume Next
Combo91.RowSource = "Select Customer.billaddressaddr2 " & _
"FROM Customer " & _
"WHERE Customer.fullname = '" & Customer.Value & "' " & _
"ORDER BY customer.billaddressaddr2;"
End Sub
I don't know if the boxes for the addresses are to be combo boxes or plain
text boxes, but I have tried it several ways and it is not working.
Any help would be greatly appreciated.
Thanks
from the customer database (of course) but I also want the address, and
shipping address to pull from the database.I have tried this code, but it
errors out at ".Rowsource" with a "method or datamember not found"
Private Sub Customer_AfterUpdate()
On Error Resume Next
Combo91.RowSource = "Select Customer.billaddressaddr2 " & _
"FROM Customer " & _
"WHERE Customer.fullname = '" & Customer.Value & "' " & _
"ORDER BY customer.billaddressaddr2;"
End Sub
I don't know if the boxes for the addresses are to be combo boxes or plain
text boxes, but I have tried it several ways and it is not working.
Any help would be greatly appreciated.
Thanks