not include autonumber record in a select query

  • Thread starter Thread starter AHizon via AccessMonster.com
  • Start date Start date
A

AHizon via AccessMonster.com

Hello,

I have a Select Query that has a criteria to only pull the record based on an
ID# from a Form. However, the Query is pulling 2 records, the record that
matches the ID# and the AutoNumber Record that doesn't yet exist. There are
default fields in the form, could this cause it to pull the AutoNumber record?
How can I only get the 1 record that matches the ID# and not the AutoNumber?
 
I think you'll find that you are only getting one record. If the existing
record is selected in datasheet view, it does say 1 of 1, right?

The "Autonumber" record is marked with a * indicating a 'placeholder' for
you to add a record. Any updateable query would have that placeholder. Once
you start adding data to the placeholder (at which point the 'Autonumber' is
replaced with a value), a new record is inserted (and a new placeholder pops
up below it). It acts pretty much the same as the >* Navigation button on a
Form.
 
Thank you for the clarification.

George said:
I think you'll find that you are only getting one record. If the existing
record is selected in datasheet view, it does say 1 of 1, right?

The "Autonumber" record is marked with a * indicating a 'placeholder' for
you to add a record. Any updateable query would have that placeholder. Once
you start adding data to the placeholder (at which point the 'Autonumber' is
replaced with a value), a new record is inserted (and a new placeholder pops
up below it). It acts pretty much the same as the >* Navigation button on a
Form.
Hello,
Click to expand...
[quoted text clipped - 7 lines]
How can I only get the 1 record that matches the ID# and not the
AutoNumber?
Click to expand...
Click to expand...
 
Back
Top