>The staic recordsource can still be a cusor, right? Or do I have to use a table for the recordsource?
>
>Thanks for all you help.
>
>Gary

Yes, it still will be a cursor.

Form's load

create cursor with the needed structure

or

select * from ... where 1=0 into GridCursor

When we're changing cursomer:

zap in GridCursor
insert into GridCursor
select *..from where Customer = m.lnCustomer

This will work if you're using VFP tables. For SQL Server select into temp cursor and then zap and insert the same way as above.