thanks Hilmar. I took your information down and will one day learn how to set up a cursor.

k

>>how would I display all records before a specific date.
>>I have a field called kdate which displays when a record was created
>>I need to call all records before April 2013.
>>
>>thanks
>>k
>
>It really depends where you want to show it. Tore's reply is appropriate for an editing form. For a report, I would SELECT all data into a cursor, something like this:
>
>

>local ldDate
>ldDate = ThisForm.LblDate.Value && I am assuming the user will type the limiting date into a form
>SELECT * FROM MyTable WHERE kDate < ldDate ORDER BY kDate INTO CURSOR Temp
>REPORT FORM MyReport
>