Hi All,
I am developing a small database app using a data environment. I would have rather use code as opposed to the data environment however, I had to show a lot of data on each form and the idea of the bound text boxes, etc. sounded good. Now that I am almost finished, I am having problems with updating the recordsets. I would like to know if there is a way to refresh a recordset. I am using tabbed forms and am running into problems after updating on one tab and switching to another tab which views the updated data, but it does not change until the form is closed and re-opened. For example: on one tab I have account information that can be updated(monthly totals, discounts, etc.). On another tab I have order information that can be updated. If I update an order, that changes the corresponding customer's balance, discounts, etc. However, the changes will not be updated on the accounts tab until the form is closed and reopened. Any info would be greatly appreciated. Thanks.
I am developing a small database app using a data environment. I would have rather use code as opposed to the data environment however, I had to show a lot of data on each form and the idea of the bound text boxes, etc. sounded good. Now that I am almost finished, I am having problems with updating the recordsets. I would like to know if there is a way to refresh a recordset. I am using tabbed forms and am running into problems after updating on one tab and switching to another tab which views the updated data, but it does not change until the form is closed and re-opened. For example: on one tab I have account information that can be updated(monthly totals, discounts, etc.). On another tab I have order information that can be updated. If I update an order, that changes the corresponding customer's balance, discounts, etc. However, the changes will not be updated on the accounts tab until the form is closed and reopened. Any info would be greatly appreciated. Thanks.
