>hi all,
>
>i need to create temperory table, at my form , and build grid via this table.
>after save ,drop this table, if i run my form again ,creat it again,
>
>if this form sharing ,if any user run this form he get deffirent table ,
>
>thanks.
You can create your temp table via Select ... into cursor csrMyCursor .... ReadWrite.
Then you can set up your grid by:
With thisform.grdMyGrid
.RecordSource = "csrMyCursor"
.Column1.ControlSource = "csrMyCursor.Field1"
... etc.
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.