Search and adding to Data Base using Dataenvironment

Im new to VB and Im having trouble with searching and Adding to a Database.

The Program Searches , but when I click on the mnuadd I have it unload the search form and load the add form. When it loads the add form it autofills the text boxes with the first field in the database. If I clear the text boxes either manually or with code then it erases that field from the data base and adds the new. From there I have it set to ask me if I would like to add another and if choose yes then clears the fields and allows me to enter in the new information with out deleting the one that I just created. My main problem is that when the add form loads I would like the fields to be blank, but not erase any information from the data base.

Thanks in advance
Joshua

Hi,

It's quite difficult to say what causes the problem in your code without actually seeing it. But one thing is clear: DataEnvironment is not he way to go. Here's an ADO tutorial here http://www.xtremevbtalk.com/showthread.php?t=39722 which explains how to do it without using DataEnvironment, ADODC control and the like.

Shurik.