I have a form with a text field (text1) that someone types in and an option group that the user has to select. Depending on what option a user selects, I have code that adds to it. Let's say the option value is 1, then code adds 100, and then that value is written to another textbox (text2). Right now I have the code written with the on click event of a command button, but I really don't like this. After text2 gets it's value, I press the next record button on the bottom of the form and everything is dandy.
Where can I place the code that increments the option so that after a user chooses an option text2 is immediately populated with the correct value? It would save the users just one more click....
The reason I have it set up this way is because I have tried using a SQL Insert statement, and also adding a new recordset in the code, but what happens is that I get 2 records, one with text1's value, and then the next one with text2's value. I probably did something wrong in setting those up, so if anyone has any ideas I would appreciate it!
Michael
Where can I place the code that increments the option so that after a user chooses an option text2 is immediately populated with the correct value? It would save the users just one more click....
The reason I have it set up this way is because I have tried using a SQL Insert statement, and also adding a new recordset in the code, but what happens is that I get 2 records, one with text1's value, and then the next one with text2's value. I probably did something wrong in setting those up, so if anyone has any ideas I would appreciate it!
Michael