clearing fields on a new form?

[StuR]

Hi all, Finally got something that resembles a database built, albeit basic.

So far, we've identified a couple of small problems, most of which I've been able to sort myself. However one I can't get sorted is with one of my forms.

Basically, if you go through and put all the information through on the form, and go to make a new form, it has the information from the previous one still there.

How can I stop it doing this? Is there something fundamentally wrong with the form construction if it's doing this or just a simple oversight on my part?

 

[CEH]

How are you trying to add a new record? Using the ">*" button in the navigation bar at the bottom?

 

[StuR]

yeah using the >* symbol at the bottom.

I know it makes a new form, it just seems to forget to refresh the contents of the form with a blank one. Which is wierd as on my other forms, which as far as I can see are exactly the same, it does refresh it with new, blank fields.

A quick glance through the properties doesn't give me any clues as to a setting I can alter to refresh this.
Worst comes to worst I can delete the form and remake it and see if the same happens, but I'd rather use that as a last ditch effort lol

Cheers,
Stu

 

[boblarson]

Sounds like you might have some unbound fields and if that is the case the controls will not necessarily clear on a new record. If that is the case then in the form's On Current event you can reset them like:

Me.YourTextBoxName = ""

or Me.YourComboBoxName = Null

 

[StuR]

many thanks bob that seems to have rectified it