Handful of records will not appear in the form

A

Amy

I can't figure this out for the life of me. I have a form that is built on a
basic query (no filters or definitions or parameters) that grabs fields from
a few tables. I have 600+ records and it has been working fine.

This form called frmMainInfo can be called from one button as data entry to
enter a new project. It is also used on a different button/screen to find a
project and open the record for the project. For 95% of the records it works
fine.

I have a handful of records that are the most recently added - I can see
them in the table, but when I go to view them in the form - the form is
completely blank. I read the KB article and tinkered with a few different
things, but I dont think there is anything wrong with my form since you can
see the majority of the records. It's just the new ones that are giving me a
problem. And it doesnt matter if these new records are added by the form or
straight into the table.

When I open the form from the button that operates as acFormReadOnly, the
screen is completely blank (no text boxes, title, close button, NOTHING).
When I open as an editable form, it shows the form with all of the boxes, but
just no data. The last weird thing is when I open frmMainInfo to scroll all
records, those records don't appear AT ALL. Not even as a blank hole where
that AutoID # should appear for that record.

Im going nuts!!! Can anyone help me sort this out?? I'm going to have a few
angry engineers on my back if I cant solve it :)

THANKS!!
Amy
 
A

Amy

Good call! And the answer is no... but I can't figure out why to save my
life! There's nothing telling the query to exclude those records?!
 
S

SusanV

Hi Amy,

Well, at least now we know to look to the query, not the form!
Open the table and the query simultaneously for a side-by-side comparison
and look closely at the records that DO show up as opposed to those that do
NOT show up. What's missing or different? Check the query criteria - is some
criteria specified that these records do not meet?
 
A

Amy

Ok I have realized now that I have both tblMainInfo and tblPermits in the
query that the form is based on. The records that are not showing up in the
permits area are not appearing in the query. I have to figure out a way to
fix that now. Thanks for helping me think through this!
 
A

Amy

I would kiss you if I could!!! I changed the SQL from an Inner to a Left join
and VOILA!!! THANK YOU!!!!
 
S

SusanV

I hear ya - something like that can drive you mad if you don't know which
direction to start in <grin>

Happy Coding!
SusanV
 
Top