In VB if I want to get a value from a table I just do a regular SLQ statement correct?
So the syntax would be???
SELECT PaymentType From CustomerTable where CustomerID = 1234
How would this look in Access VB, and how would I access this value? What I want to do is have a field automatically populated when filling out a form. When a specific field loses focus, I want to query the customer table to find the payment type, and then use an if statement to calculate the value to populate into a different field.
So the syntax would be???
SELECT PaymentType From CustomerTable where CustomerID = 1234
How would this look in Access VB, and how would I access this value? What I want to do is have a field automatically populated when filling out a form. When a specific field loses focus, I want to query the customer table to find the payment type, and then use an if statement to calculate the value to populate into a different field.