Hello Ravi.

If I choose a date from the calendar object, then the grid is repopulated by an SQL statement which displays the data for 7 days beginning from the date I selected. Here are the observations:

As a follow up to my pervious message, I bet this is the culprit. I do not know how you are populating the grid's RecordSource, but I bet you are getting the error when you rebuild it.