RuntimeBug

[bon]

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

[Maartin]

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]
-----------------------

[bon]

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.

[Maartin]

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]
-----------------------

[Maartin]

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]
-----------------------

[Buzby]

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]