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
|
|||
|
|||
Form is filtering out values
First off, I'm an Access newb, so sorry in advance for the kindergarden-ish
question... I have a simple form where we collect customer information, which is stored in our "main" table. On this form is a "site id" field, which is a unique # for a particular location. Prior to today, the site ID (and corresponding info - addr, city, st, zip, etc.) was all manually entered in the form (and thus, into the "main" table). I figured out that I could just use the "site ID" field in the form and then link the corresponding data from my table ("site data") into the form (rather than having users type it all in). All's well and good -- modified the form and the corresponding data shows up as I expect it to. HOWEVER, now the form is filtering out all records that DON'T contain a site ID and I still need the records where site ID is blank to show up. I've searched the forums, and tried the help feature within access, but can't seem to find where I can fix this. Any help is appreciated. Chris |
#2
|
|||
|
|||
Form is filtering out values
Create a query for your table. Make sure that everything shows in the query,
and base your form on the query. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Chris" wrote in message ... First off, I'm an Access newb, so sorry in advance for the kindergarden-ish question... I have a simple form where we collect customer information, which is stored in our "main" table. On this form is a "site id" field, which is a unique # for a particular location. Prior to today, the site ID (and corresponding info - addr, city, st, zip, etc.) was all manually entered in the form (and thus, into the "main" table). I figured out that I could just use the "site ID" field in the form and then link the corresponding data from my table ("site data") into the form (rather than having users type it all in). All's well and good -- modified the form and the corresponding data shows up as I expect it to. HOWEVER, now the form is filtering out all records that DON'T contain a site ID and I still need the records where site ID is blank to show up. I've searched the forums, and tried the help feature within access, but can't seem to find where I can fix this. Any help is appreciated. Chris |
#3
|
|||
|
|||
Form is filtering out values
Are you using a form with the siteID (from the main table) and a subform
with details addr cty etc? (based on another table?) linked by the siteID? If your main table doesn't have a blank ID to match the Blank IDs in the subform it the will not show them. You could create a record with a blank ID in you main table/Main Form (that may be difficult depending on your design) Replace the blank IDs with a dummie ID 'noID' or 0 (zero) depending on your datatypes and make a record in your main form to match If you are not using a form and subform, disregard this message "Chris" wrote in message ... First off, I'm an Access newb, so sorry in advance for the kindergarden-ish question... I have a simple form where we collect customer information, which is stored in our "main" table. On this form is a "site id" field, which is a unique # for a particular location. Prior to today, the site ID (and corresponding info - addr, city, st, zip, etc.) was all manually entered in the form (and thus, into the "main" table). I figured out that I could just use the "site ID" field in the form and then link the corresponding data from my table ("site data") into the form (rather than having users type it all in). All's well and good -- modified the form and the corresponding data shows up as I expect it to. HOWEVER, now the form is filtering out all records that DON'T contain a site ID and I still need the records where site ID is blank to show up. I've searched the forums, and tried the help feature within access, but can't seem to find where I can fix this. Any help is appreciated. Chris |
Thread Tools | |
Display Modes | |
|
|