Form is filtering out values

[Chris]

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

 

[Arvin Meyer [MVP]]

Create a query for your table. Make sure that everything shows in the query,
and base your form on the query.

 

[Chegu Tom]

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