There can be quite a few problems, first do you have permissions in the
database to Add New records?
What is the ADO control attached to...SQL Query text? Stored Procedure?
Table?
Is the validation on the text boxes or other controls set?
All of these can cause problems. Have you tried to add your query or stored
procedure to the dataenvironment and just drop the fields on the form. If
you do you will have to go into the properties of the command and change the
READ ONLY status if you want to add new records.
Scott
Quote:
> Please help
> I have added an Ado data Control to a form and all the textboxes are
bound.
> Everything works fine as long as there is at least one record in the
> database. When I empty the database and try to add the first record, the
> textboxes wipe out their data
> as I tab from textbox to textbox on the form. How do I prevent this from
> happening?
Adodc Problem