No input updating

[TTD]

Hi,

I have a form (input type) which is based on a table. Let's say it has 2
fields

1: numeric keyfield
2: textfield.

When the form opens the numeric is automatically added with 1. When I leave
the textfield empty and I close the form, the database is being written. Bu
tI don't want that to happen, if the textfield is empty.

With which command can I prevent Access from writing to the table when I
close the form?

Thanks in advance.

[WindAndWaves]

Are you saying - if the text is not completed then do not save the record???

You could make the textfield compulsory or you could write a little code
that would undo the changes to the numeric field if the text field is not
completed

Thirdly, you could unlink the numeric field and add the data from the
numeric field using SQL if the text field is completed.

Let me know which one sounds best and I will provide more details.
"TTD" <tt*@hotmail.com> wrote in message
news:c8***********@beast.euro.net...

Hi,

I have a form (input type) which is based on a table. Let's say it has 2
fields

1: numeric keyfield
2: textfield.

When the form opens the numeric is automatically added with 1. When I leave the textfield empty and I close the form, the database is being written. Bu tI don't want that to happen, if the textfield is empty.

With which command can I prevent Access from writing to the table when I
close the form?

Thanks in advance.

---
Please immediately let us know (by phone or return email) if (a) this email
contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.688 / Virus Database: 449 - Release Date: 18/05/2004

[TTD]

Hi WaW

I don't want to make the textfield compulsary. If the user enters the form
by accident or cahnges his mind and want to leave, then I don't want him to
be bothered by Access.

Undo the changes to the numeric field would be fine. (though unlinking
sounds also interesting).

Thanks in advance

"WindAndWaves" <ac****@ngaru.com> schreef in bericht
news:0Q*******************@news.xtra.co.nz...

Are you saying - if the text is not completed then do not save the record???
You could make the textfield compulsory or you could write a little code
that would undo the changes to the numeric field if the text field is not
completed

Thirdly, you could unlink the numeric field and add the data from the
numeric field using SQL if the text field is completed.

Let me know which one sounds best and I will provide more details.
"TTD" <tt*@hotmail.com> wrote in message
news:c8***********@beast.euro.net...

Hi,

I have a form (input type) which is based on a table. Let's say it has 2
fields

1: numeric keyfield
2: textfield.

When the form opens the numeric is automatically added with 1. When I leave

the textfield empty and I close the form, the database is being written.

Bu

tI don't want that to happen, if the textfield is empty.

With which command can I prevent Access from writing to the table when I
close the form?

Thanks in advance.

---
Please immediately let us know (by phone or return email) if (a) this

email contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.688 / Virus Database: 449 - Release Date: 18/05/2004