RuntimeBug

There is this form that has textboxes which saves to the database.
Each time this form is opened at runtime, previuosly saved data appear on the textboxes.

What can I do to open a run a clean form?

thank you!

--------
bon

Do you bind the textboxes to a datacontrol and the datacontrol to the database ?

If you have, the only way so far that I have seen that solves the problem is to use a recordset and not the datacontrol.

I'll ask around here. Somebody had the same problem. Maybee they know.

------------------
Have Fun.
Maartin.
[email protected]
-----------------------

Yes Maartin, my textboxes have been binded to a datacontrol and the datacontrol to the database.

Does this has to do with the EOF or BOF functions?, because the problem is that my form does not refresh.

Please help.

Bon.

I will ask the juniours in office they also use data controls for their projects. I tend to prefer useing recordsets, more controls less problems. I know one of them had this same problem, if they fixed the error and still use the datacontrol, I will give you the answer, other wise sorry sad news but recordsets will be the answer from me.


------------------
Have Fun.
Maartin.
[email protected]
-----------------------

Got some sort of answer for you.

You must check the state of you edit mode before you change the edit mode to something else.

Apperently it fixed her error.

------------------
Have Fun.;)
Maartin.
[email protected]
-----------------------

I agree that data controls are a bit old hat these days but when you may find when you start an AddNew

ie; DataControl1.Recordset.AddNew

the boxes will clear as they a ready for a new record.

(don't forget to do a .Update on the "SAVE" button or the data will be lost)

------------------
Mark "Buzby" Beeton
VB Developer
[email protected]