ControlSource in a Grid

[ScottMcVt]

I have used a table AGAIN in another work area. I want a grid to display the contents of the "used again" table, but the grid is always empty. Is there a problem with setting the ControlSource of a grid to the "used again" alias of a table ?

Thanks,
Scott McWherter

 

[ramani]

HI
In the RecordSourceType of the Grid, set the value = 1 (ALias). May be you are using it as 0 (Table)

MyGrid.RecordSourceType = 1

Hope this helps you ramani
(Subramanian.G),FoxAcc, ramani_g@yahoo.com

 

[ScottMcVt]

I have the RecordSourceType set to 1(Alias). Thanks.

 

[chpicker]

Are you setting the controlsource at design time or at runtime? Where are you using the table AGAIN, in the form INIT() method?

If the grid is created before the cursor exists, it will unbind itself and become blank. To avoid this, either leave the ControlSource property blank at design time and set it after the USE ... AGAIN command, or put the code in the form's LOAD() event, which will fire before the grid is created.

Hope that helps,

Ian