table-query-entry form

[bert]

I'm a new user with Access 2007 and need help please. I have a client
database table that has a field indicating if the client is active or
inactive by using A or T.
I have created a query to show only A clients. Off the query I have created
a data entry form as we only want the active clients to show in the entry
form for quicker entry of data.

The problem I am having is the query is not showing new client entries and
therefore is not showing up on the data entry form either. However, the new
client entries are in the client database correctly.

Have I gone about this the wrong way or is there an easier way to make this
work?

 

[John Spencer MVP]

Do new client entries have nothing (null) in the field that indicates whether
or not a client is active or inactive? If so and you are using that field to
filter the records you will need to add a test to get the records where the
field is null as well as where the fields is equal to "A".

In the query design view (assuming field is named Status, you would need

Field: [Status]
Table Name: [Your table Name]
Criteria (line 1): = "A"
Criteria (Line 2): Is Null


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County