My Form does not contain all the data in the Query?

[Gezza]

Hi,
Hope someone can help.
I have a Form based on a Query but the Form does not show all the data? Could there be something, a setting perhaps, that I am not aware of that is restricting/filtering the data? I have looked but cannot see anything obvious

Thanks in advance
Gezza

[RuralGuy]

Do you have controls on the form bound to the fields you want to display?

[Gezza]

Hi RuralGuy, Thanks for your response.
No not that I'm aware of, I what to display ever record, but how can I check?

[RuralGuy]

Your first post indicated you were not displaying all of the data. What did you mean by that?

[Gezza]

If I view the data in the query which is sequentially numbered 1 to --- I know I have each line of data. When I open the Form it jumps/misses lines of data that I know are in the Query?

[RuralGuy]

Do you have a Sort clause in your query?

[Gezza]

No, no sorting on any field

[RuralGuy]

Add a Sort to your query and see if the results are then the same.

[Gezza]

That seems to have worked, I would never have thought of it, and I'm surprised that NO sort could cause a problem like that.
Thank you, You know what they say, "you live and learn".

[RuralGuy]

The Jet Engine thinks of a table as a bucket of records and unless you request an order for the records will return them in the fastest manner possible at the time. This means without an order there is no guarantee on which records you get first.