How to stop a form adding a new record when changes are made on the form....

[105ben]

Hello,



I have a form and when I open it I add a value automatically (via code on form load) to one of the text boxes. This then creates a new record in the database, which I dont want.

The user will sometimes go onto this form to simply see if a record exists. Currently, if it doesnt a blank one it created. This messes up all sorts of other things I do in the database, like compile stats.

Any ideas how to prevent this? I know it can be done, as Ive done it before! I have another form which doesnt add a new record, but i cant remember how I did it.... and cant work it out on the form. Both forms are bound to tables too.

[rpeare]

instead of populating the value automatically why don't you wait until they start typing in the main record.

You're using a bound form and if you do something like

[dateAdded] = date()

you are forcing a new record to be created.

Instead do something in the ON EXIT property of one of your required fields (let's call it TESTFIELD) like

If Not Isnull(TESTFIELD) Then
    [DateAdded] = date()
endif