Search and adding to Data Base using Dataenvironment

jkeene
10-17-2004, 12:46 PM
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

Shurik12
10-17-2004, 03:35 PM
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.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum