When a form doesn't diplay all of record source

bknight
BronzeLounger
Posts: 1391
Joined: 08 Jul 2016, 18:53

When a form doesn't diplay all of record source

Post by bknight »

I have a query and for Hans' sake I created a form from it. The problem: the form does not display all the records of the query, how can this be?
Below is an partial image of the query, partial of the form and an image of the property sheet of the form.
Notice that the query has seven records and the form has only four.
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 78530
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: When a form doesn't diplay all of record source

Post by HansV »

That's weird. Could you attach a zipped copy of the database, or send it to me?
Best wishes,
Hans

User avatar
HansV
Administrator
Posts: 78530
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: When a form doesn't diplay all of record source

Post by HansV »

Thanks for sending me the database. This is what I see:

S2540.png

The query and the form both display 7 records.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

bknight
BronzeLounger
Posts: 1391
Joined: 08 Jul 2016, 18:53

Re: When a form doesn't diplay all of record source

Post by bknight »

Maybe something was hung and the shut down reopen solved that issue. I see seven records in both today also.
Sorry for the bother.