Data or Flex Grid....

[Kicker]

I tried a sub-form and it didn't even come close to what I want. So here goes....Using VB6, I would use a FlexGrid control and be done with it. However, Using Access and VBA, I need some help.

I have a query that will regularly give me approximately 75 records. I need to be able to choose a cell, click on it and make it active. Depending on the contents of the cell, I need to do one of several things. Primarily, I want to be able to initialize a public variable and Drag and Drop the cells contents to a text box leaving the cell empty.

In essence, I need to be able to use the properties
.value
.row
.column
.etc

Is there an Access or VBA equivalent to the FlexGrid?

I found a "Datagrid" control, but could not figure out how to use it.

ttfn
Kicker

 

[Pat Hartman]

If you set the subform to datasheet view, it will look like a grid. The columns will be sizable and movable. You would put your code in the double-click event. Don't use the click event because that makes it too easy to execute the code accidentally.