View Full Version : updating fields when form refreshes


aris
03-11-2002, 11:46 PM
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
03-12-2002, 01:22 AM
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
03-12-2002, 01:24 AM
Thank you!!!

How do I bound the text fields?

Fizzio
03-12-2002, 01:54 AM
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
03-12-2002, 05:17 AM
Thank you!!!