>In one of my forms I have a grid with 10 columns and up to 15 rows where the user can enter a number of short values and then save the values to some permanent tables. The grid has been based on rows of a work table which are related to the parent record of the form. Periodically the work table has to be changed to accomodate changes in the database.
>
>I would like to use a cursor instead of a work table. I've written the code to generate the cursor each time the form is entered. I like this approach better because it is self-maintaining. And also because each user gets their own temporary DBF file with no possibility of trying to use the same rows in the worktable.
>
>Unfortunately after changing my grid to have the cursor as a record source (type 1-alias) it doesn't show any data.
>
>Is this possible? What am I missing?
>
>Peter Robinson
Before you rebuild the record source cursor, set the RecordSource property to "", rebuild your cursor, and then set it back to your cursor name.