Canceling adding a record

I am getting back into Access please forgive me.

How do you cancel the adding of a record if you are adding a record by the
navigation button?

I hit the * to add a record but then I decide not to and I pres the
previous button.

Dorian,
What you're doing (*) is "navigating" to a New record... you really
haven't created one yet. You didn't enter any data into the New record, and
Access knows that.

So.... if you got to Previous... or First... or any other record... or
even exit the form altogether, you'll (in affect) be "cancelling" the New
Record.

Once you enter data into (and update) a new record, then it will be have
to be deleted.
hth
Al Camp

"Dorian Chalom" wrote in message
...
I am getting back into Access please forgive me.

How do you cancel the adding of a record if you are adding a record by the
navigation button?

I hit the * to add a record but then I decide not to and I pres the
previous button.

OK...but there a couple fields on the form that are combo boxes based off of
a Select statement and those fields are auto filled. So, How do i delete
the record, or atleast trap the primary index cannot be null and delete the
record and allow the user to go to the previous record?


Thanks for your help

"Al Camp" wrote in message
...
Dorian,
What you're doing (*) is "navigating" to a New record... you really
haven't created one yet. You didn't enter any data into the New record,
and Access knows that.

So.... if you got to Previous... or First... or any other record... or
even exit the form altogether, you'll (in affect) be "cancelling" the New
Record.

Once you enter data into (and update) a new record, then it will be have
to be deleted.
hth
Al Camp

"Dorian Chalom" wrote in message
...
I am getting back into Access please forgive me.

How do you cancel the adding of a record if you are adding a record by
the navigation button?

I hit the * to add a record but then I decide not to and I pres the
previous button.

Put some logic in the Before Update event of the form to determine whether to
add the record or not.

"Dorian Chalom" wrote:

OK...but there a couple fields on the form that are combo boxes based off of
a Select statement and those fields are auto filled. So, How do i delete
the record, or atleast trap the primary index cannot be null and delete the
record and allow the user to go to the previous record?


Thanks for your help

"Al Camp" wrote in message
...
Dorian,
What you're doing (*) is "navigating" to a New record... you really
haven't created one yet. You didn't enter any data into the New record,
and Access knows that.

So.... if you got to Previous... or First... or any other record... or
even exit the form altogether, you'll (in affect) be "cancelling" the New
Record.

Once you enter data into (and update) a new record, then it will be have
to be deleted.
hth
Al Camp

"Dorian Chalom" wrote in message
...
I am getting back into Access please forgive me.

How do you cancel the adding of a record if you are adding a record by
the navigation button?

I hit the * to add a record but then I decide not to and I pres the
previous button.

Are you assigning a Default Value or are you actually assigning a value to
the field? You should just assign a default value. If you've merely
assigned a Default Value, moving to new record doesn't create a new
record...until you start inserting data in the fields/editing.

--
Paul Overway
Logico Solutions
http://www.logico-solutions.com


"Dorian Chalom" wrote in message
...
OK...but there a couple fields on the form that are combo boxes based off
of a Select statement and those fields are auto filled. So, How do i
delete the record, or atleast trap the primary index cannot be null and
delete the record and allow the user to go to the previous record?


Thanks for your help

"Al Camp" wrote in message
...
Dorian,
What you're doing (*) is "navigating" to a New record... you really
haven't created one yet. You didn't enter any data into the New record,
and Access knows that.

So.... if you got to Previous... or First... or any other record... or
even exit the form altogether, you'll (in affect) be "cancelling" the New
Record.

Once you enter data into (and update) a new record, then it will be
have to be deleted.
hth
Al Camp

"Dorian Chalom" wrote in message
...
I am getting back into Access please forgive me.

How do you cancel the adding of a record if you are adding a record by
the navigation button?

I hit the * to add a record but then I decide not to and I pres the
previous button.

If the Form has been dirtied, the user can hit Escape once or twice (the
first Escape ondoes the Active Control if required and the second Escape
undoes the Record add/edit) to cancel the addition.

--
HTH
Van T. Dinh
MVP (Access)



"Dorian Chalom" wrote in message
...
OK...but there a couple fields on the form that are combo boxes based off
of
a Select statement and those fields are auto filled. So, How do i delete
the record, or atleast trap the primary index cannot be null and delete
the
record and allow the user to go to the previous record?


Thanks for your help

Thanks. How could i automate that once they hit another navigation key?

"Van T. Dinh" wrote in message
...
If the Form has been dirtied, the user can hit Escape once or twice (the
first Escape ondoes the Active Control if required and the second Escape
undoes the Record add/edit) to cancel the addition.

--
HTH
Van T. Dinh
MVP (Access)



"Dorian Chalom" wrote in message
...
OK...but there a couple fields on the form that are combo boxes based off
of
a Select statement and those fields are auto filled. So, How do i delete
the record, or atleast trap the primary index cannot be null and delete
the
record and allow the user to go to the previous record?


Thanks for your help

See Klatuu's post in this thread.

--
HTH
Van T. Dinh
MVP (Access)


"Dorian Chalom" wrote in message
...
Thanks. How could i automate that once they hit another navigation key?