Select Item Row from MSHFlexGrid?

[rtshort]

I have a form with a MSHFlexGrid (frmInvoice) and I am calling items from a SQL Database to load another MSHFlexGrid (frmChoose). The frmChoose needs to pull up parts from a database. Most parts have 2 choices(OEM and ReMan) When I use the SQL Statement I only get one part and not the other.

"Select * from Parts Where PartName = 'WaterPump'"

I'm sure I have to include the "i" counter but can't quite seem to figure it out.

Also I need to be able to select a row from the frmChoose and add it to the frmInvoice.

I call PartName because even though it's not the primary key, I have taken time to make sure all PartNames are unique. Every day above ground is a GOOD DAY!!!

 

[JohnYingling]

Use .Rows = to increase # of Rows.
use .row = and .col = to set current row and focus.
use .textmatrix to get or set a cell with changing focus.

TextMatrix Property
Returns or sets the text contents of an arbitrary cell.
Syntax
object.TextMatrix(rowindex, colindex) [=string]

http://WWW.VBCompare.Com

 

[rtshort]

Thanks for taking the time to answer John. Gives me a start in that direction. Every day above ground is a GOOD DAY!!!