updating fields when form refreshes

[aris]

Hello!

I am using acess 97.

In my form, I have many text fileds.
When i enter data and submit it, in the next page were new data can b entered, the text fields still show the old data by default.

How can I make it so that the form starts blank (I mean the text fields as well).

Thank you very much!

 

[Fizzio]

Make sure that
a) you have not set a default value in the properties box in design mode.
b) (More Likely) Ensure that the control is bound to a field you want to store that data in. If it is not bound, it will continue to display whatever you typed there previously and the data you typed will not be stored.

HTH

 

[aris]

Thank you!!!

How do I bound the text fields?

 

[Fizzio]

In the design mode of your form.
Select the form (Click on the grey square on the top left of the form)
Goto Data and check what the Record Source is (In the Properties Box).It would normally be set to the name of a table or query.
Select the fields you are having trouble with (one at a time) and on the Data Tab in the properties box select the Control Source and use the dropdown box to choose which field you wish to store the data in.

hope this is clear.

 

[aris]

Thank you!!!