Saving to database

[ad1044]

I have a save button on my form and the code behind it is Data1.Updaterecord
The user enters in all there infor to textboxes and clicks this button so the info in stored to the access 97 DB. But most of the time when this is clicked it populates all the textboxes with a previous record....Is there someway to stop this or a better way to save to the database..PLEASE HELP

If I understand what you're trying to do, a simpler way is to take a one of the data controls and use it to open a database. Then set the datasource and datafield properties of each text box and all the edits and updates will happen automatically.

[ad1044]

I do have the fields already bound to the database if thats what u mean. And they do save automatically....But they dont show up in the datasbe until I exit the program and come back in...Which doesnt work for my app...