If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
table-query-entry form
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? |
#2
|
|||
|
|||
table-query-entry form
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 bert wrote: 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? |
Thread Tools | |
Display Modes | |
|
|