Hi everyone. I been trying to work out why my query wont display the results in the form. The query works and will show results in datasheet view. But i really want it to display it throught the form that i use to input those same data. The primary key is Date field. I am using short date.

Primary key a short date? This means only one record per day??!!

Unless you have a filter on the form of some kind the form should just 1:1 display what the query grid shows.