• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 238
  • Last Modified:

extra record created in query

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
1 Solution
Take a look at table1.....the first record is blank.   Edit your table and the 'extra' record will be removed.

Good luck
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.
The record is already  in your table so it will always appear in the query.
Delete it from the table.

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Rey Obrero (Capricorn1)Commented:
test this

Rey Obrero (Capricorn1)Commented:
if you want to see the date when you open the form, use this
davetoughAuthor Commented:
thank you
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.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now