Hi, I'm new to iGrid and am using this to show bookings against dates. So far I have managed to bind a recordset to the grid in an Access 2013 form. The issue I have is that when the user clicks on a cell that has a text value in it, in my case a string value, I want to be able to capture that value to another unbound text box on the form. The other issue though is that the field names change as well as the number of fields, in the table based on the data held within the pivot query at the time. is there any way of doing this without using an array? I see that the tooltip shows the value when hovered over the cell. Can I capture that as a last resort?

Any help greatly appreciated, thank you.

The text of any cell you clicked can be retrieved using the CellValue property.

If you populated the grid using the FillFromRS method, column keys are field names and can be retrieved using the ColKey property.