Hooking DB to FLexGrid Problems

[MartinLiss]

As to your last question, it would help to see your code, but the problem is probably that you are not setting MyGrid.Col = 0 before you start loading the data.

------------------
Marty
COGITO EGGO SUM
I think; therefore I am a waffle.

[VBAmateur]

Hello I am tryin to allow my users to click on a command button that will take them to a new form that holds a grid (table) that will show the records for the chosen account # from the initial form and the transactions that have been done for only that account. I am currently using DAO and I have inserted a FlexGrid. Is that what I should use? Second I need to see how to insert the sql statement for that grid that will choose records only for the chosen account number (as stated before - that they choose on the first form). And last question, while I am at it, My current grid (that shows all transactions) is not aligning the fields as they are in my Access DB. For example it is putting my first field (which is accountNum) in the Access table as the last field in the FlexGrid when I run it and I need the account num to be the first filed in the Grid. Thankyou Immensely for your replies...