>>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
>
>This is just a thought. Why not place a shape control over the record selectors visual portion to create the asthetic effect and still get the normal functionality.
Our goal is to have the capability of clicking anywhere on the row and selecting the record, hence the rowcolchange event. Conceptually, it seems like what I have should work, I just feel like I'm missing something.