extra record created in query

hello,
i have attached db- open database-form opens
if you select name from combo box and click completed.
Then press run query-
you will see I have one extra record always displaying on top-
is there a way not to have this.
I am trying to have time stamp w/name.
thank you
Database.mdb
davetoughAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
if you want to see the date when you open the form, use this
Database.mdb
0
 
DoveTailsCommented:
Take a look at table1.....the first record is blank.   Edit your table and the 'extra' record will be removed.

Good luck
0
 
Patrick MatthewsCommented:
In addition to that, your 'Completed' button is allowing users to add records to that table where the name is blank.  So, even if you remove that current blank row, your users will probably just ad more in the future.

Also, word of advice: NEVER just leave your control names as Command7 or Command26.  ALWAYS give them meaningful names.
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
peter57rCommented:
The record is already  in your table so it will always appear in the query.
Delete it from the table.

0
 
Rey Obrero (Capricorn1)Commented:
test this


Database.mdb
0
 
davetoughAuthor Commented:
thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.