Form displaying data works half of the time (1 Viewer)

nstratton

Registered User.
Local time
Yesterday, 21:27
Joined
Aug 30, 2015
Messages
85
I have a form based on a query where the data can be filtered by the AutoNumber ID. What is interesting with this is only certain ones will show data and others pull up blank. The function is to show an expanded view of the entry selected.

The only criteria is this AutoNumber so something tells me that is not it. It could be something wrong with the screen before where the selection is made. It is just weird that only certain ones will show. Any ideas will be appreciated because I am at a complete lost on this one.
 

The_Doc_Man

Immoderate Moderator
Staff member
Local time
Yesterday, 21:27
Joined
Feb 28, 2001
Messages
27,407
If the form is based on a JOIN query with parent/child relationships and there is a chance that the child-side might not be populated AND the JOIN is an INNER JOIN, that might do it.
 

Users who are viewing this thread

Top Bottom