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
>SELECT * FROM MyTable WHERE kDate < ldDate ORDER BY kDate INTO CURSOR Temp
>REPORT FORM MyReport
>