DBGrid - OnCellClick & OnDblClick, return a form/TBMemo containing cell/column value/s
<p>I'm using the following code added to my DBGrid - OnCellClick event</p>

<pre><code>procedure TForm2.DBGrid1CellClick(Column: TColumn);
begin
if dbmodule.comenziDataSet.Active then
  begin
    if not Assigned(dbgridCelulaForm) then
    begin
      dbgridCelulaForm := TdbgridCelulaForm.Create(Self);
      dbgridCelulaForm.DBMemoCelula.DataSource := dbmodule.comenziSource; 
    end;

    dbgridCelulaForm.Visible := False;
    dbgridCelulaForm.Visible := True;
    dbgridCelulaForm.DBMemoCelula.DataField := Column.FieldName;
    dbgridCelulaForm.Caption := Format('%s / randul: %d',[Column.FieldName, DBGrid1.DataSource.DataSet.RecNo]);
  end;
end;
</code></pre>

<p>dbgridCelulaForm = name of the form containing the <code>TDBMemo</code>
DBMemoCelula = name of the <code>TDBMemo</code>
dbmodule.comenziDataSet = comenziDataSet is the name of the <code>DataSet</code> and dbmodule is the name of a <code>data module</code> (unit, like forms) - the <code>DataSet</code> is on the <code>data module</code>, so, dbmodule.comenziDataSet
dbmodule.comenziSource = same as data set, a DataSource on a data module, the source is named comenziSource</p>

<p>Ok so what this code does:</p>

<p>Once I click a cell on my <code>DBGrid</code> it pops up a <code>form</code> (named dbgridCelulaForm) which contains a <code>TBMemo</code> (named DBMemoCelula) and it shows me the information contained in that cell (like, a Customer Name for example, or whatever the cell is holding, in my db)</p>

<p>This is fine, my problem is I can't select rows now in <code>DBGrid</code>, well, I can but once I do the 1st place I click (a cell, any) on the particular row I want to select with my mouse, then cell activates and the <code>form</code> pops up.</p>

<p>Is it possible to use this code in <code>DBGrid</code> - <code>OnDblClick</code> event instead of the <code>OnCellClick</code> ?
Meaning once i double click a row / cell the <code>form</code> should pop up and show me the info, but double click - not single click.</p>

<p>That way, I can still select the row and still view the info in the cell if I need to.</p>

<p>Or any other way/place to use/receive this functionality.
Any thoughts?</p>

<p>I can post a quick video of everything if my explanation is ambiguous and you think that would help, just tell me in the comment / answer.</p>

<p>Also, I'm using RAD Studio 10 Seattle and dbexpress components for the database - if that helps.</p>

<p>Thanks!</p>