I have a form with 3 BOUND text boxes.
box1
box2
box3
I want to have a comand button that populates those boxes when clicked.
The values are to be looked up via a corresponding product#.
I.E.
Product1 box1
Product2 box2
Product3 box3
So to find the value for each, there would be an SQL statement. I.E.
Use Product1 value to look up the value that is put in box1.....etc,
etc....
I think this will work, but am not quite sure how the code would go....
Any help would be appreciated.
Doug