Query - how to get the blank form to show, not search the databas.

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

Guest

I built a query and saved it with no information in any field. When I click
on the query, I get all the records in the database, when what I really want
to do is have a blank query come up so that I can enter information into the
query. Am I approaching this wrong? I have an unlimited number of queries
of course, and I don't want to have to set up a separate query of each
different combination of data.
 
A query is used to "query" the database. It locates information. You may
also add records there.

Most people would create a form in which to add or edit records. The form
could be based on your query. The form can be set as "data entry" if you do
not wish to see previously-entered records.

Rick B
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

#error - Blank 3
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
My Access query shows blank in the label merge 1
Combine Duplicates in Query 0
One query blanking another 8
Query using two separate query totals 3
Data Not Displayed in Query 2
Blank or Null in a Cross Tab Query in Access 2003 2

Back
Top