I've been working on this with a colleague for days and we have both just about given up. We have a DBGrid that we took out record selectors (for asthetic purposes) and we use the rowcolchange event to select a row (highlight it) then our double click procedure to add it to another grid. My question is how can get our double click event to fire both procedures? Here's the code.
Private Sub dbgBOM_DblClick(Index As Integer)
cmdAddToCart_Click (Index)
End Sub
Private Sub dbgBOM_RowColChange(Index As Integer, LastRow As Variant, ByVal LastCol As Integer)
' DoEvents
If DeleteFL = 1 Then
'won't bring up ser # box if Just loading
DeleteFL = 0
Exit Sub
End If
dbgBOM(Index).SelBookmarks.Add dbgBOM(Index).Bookmark
'redo below comments after all data is working
' If Not datItem.Recordset.EOF Then
ModSC$ = dbgBOM(Index).Columns(0).Value
CompSC$ = dbgBOM(Index).Columns(1).Value
ItemSC$ = dbgBOM(Index).Columns(2).Value
QtySC = dbgBOM(Index).Columns(3).Value
PriceSC = dbgBOM(Index).Columns(4).Value
ExtPriceSC = dbgBOM(Index).Columns(5).Value
' dbgBOM_Click (Index)
End Sub