altecjjf
asked on
SQL and Visual Basic (VB 5)
DataCustomer.RecordSource = "Select * from Customers where Customer_ID = " & UserInputByCustomerID
DataCustomer.Refresh
This works for a number, but not for text. How can i get this SQL to work from a Access database to access a record for somebody's last name.
DataCustomer.Refresh
This works for a number, but not for text. How can i get this SQL to work from a Access database to access a record for somebody's last name.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER