Controlling when a new record is generated

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using a basic continous form, how do I set up the form to not create a new
record until the end of the tab order is reached? Currently it's generating a
new record as soon as the user types into the first text box(tab stop). I'm
assuming a event action is required on the last field, but what will stop the
auto-generated record in the first field? Some code would be apprieciated.
Thanks.
 
Hitting ESC will cancel the addition of the record. Your record is not
CREATED when you start typing. It is not saved to the table until the end.

Your AUTONUMBER field IS updated as soon as you start typing in a record.
Even hitting ESC will 'burn' that number and move on to the next. Since an
autonumber is only designed to create a unique key, it should not matter to
you at all. If you are using an autonumber field to represent some peice of
data (an invoice number, a customer number, etc.) then you are misusing
autonumbers!

For more details on this topic, search the hundreds of previous posts on the
topic. You can see previous posts by going to Google.com and clicking the
"groups" link.

Then type

microsoft.public.access

followed by keywords you'd like to search. for example....


microsoft.public.access autonumber reset

or

microsoft.public.access autonumber missing numbers

or

microsoft.public.access autonumber gaps
 
Let me rephrase the question. Maybe it's not a new 'record' that is created,
but a new line of input fields (line 2) is generated on the screen as soon as
the user begins typing into the first field (line 1). I'd like to control the
form so the new line isn't produced until the user presses tab out of the
last field. Seems to me I have to set the action on the first and last fields
to accomplish this.

Thanks.
 
As far as I know, you can't control that. The whole point is that you could
type in a few items, then click that new record to move to it. In short,
Access is allowing you to add new records in a form, once you start typing
in a record, you need something to click if you want to save it and start
another new record.
 
Back
Top