Show only 3 fields in Grid

[Menglish]

I am trying to show only three fields in my grid and they are not in the table field order. I use properties and select the three fields and have the grid properties set to 3 columns but when I run the form, it lists the fields in the order of the tables fields and adds the bottom scroll bar.

I have the tables opened and I have "recordsource" set for each grid. What am I missing.

Thanks for any comments.

Millard

 

[ramani]

Method1:

SELECT myField1, myField2, myField3 INTO CURSOR myCursor

and set myCursor as your Grids table

Method2:
In the grids column controls.. set the following preperties.

myGrid.Column1.ControlSource = myField1
myGrid.Column2.ControlSource = myField2
myGrid.Column3.ControlSource = myField3


This willsolve your problem

ramani
(Subramanian.G)

http://winnersoft.coolfreepages.com/

 

[foxbldr]

Ramani,

Since Menglish opens the table at the start, we better write;

myform.grid1.recordsource=""

to avoid automatic grid population. Then the SQL statement, etc, etc.

Foxbldr