I have a Split form (Access 2007 with VBA) with some text boxes which are not bound and are used to enter data, some other text boxes are bound to allow display of records in the datasheet section of the form.
I enter data in the unbound text boxes and used a parametrized insert query to insert the data into the database. After inserting I do Me.Requery to update the datasheet section, when I do that it reset the values in the unbound text boxes to the value that was there before I clicked the insert button. How do I requery the datsheet only or prevent the data in the text boxes from cahnging.
here is what I do
Text90.value = 90 I change to Text90.value =100
Click on Insert button which calls an insert query
Me.Requery
Text90.value goes back to 90 but he datasheet section shows the correct value which is 100
I enter data in the unbound text boxes and used a parametrized insert query to insert the data into the database. After inserting I do Me.Requery to update the datasheet section, when I do that it reset the values in the unbound text boxes to the value that was there before I clicked the insert button. How do I requery the datsheet only or prevent the data in the text boxes from cahnging.
here is what I do
Text90.value = 90 I change to Text90.value =100
Click on Insert button which calls an insert query
Me.Requery
Text90.value goes back to 90 but he datasheet section shows the correct value which is 100
