Using form entries to locate a table row

[arcrazr]

Hello,

I am trying to located a row in a table [turnoverdata] using entries from a userform (Update). The three columns together should provide a key that will isolate the entry to one row only. (This code should be able to aide that function as well when creating the table entry in the first place in my imagination). The values of the three userform comboboxes are set using code and values from the table so, only entries that already exist should be able to be searched.

So far the best I could come up with is below. I compile okay but get an error that 'object doesn't support this property or method' I have tried setting 'row' as a range, listobject, long. same result

Any help would be appreciated.

Private Sub find_Row()
Dim row As Long
row = [TurnoverData].Index([TurnoverData], [TurnoverData].Match(CDate(Me.CBODateUpdate.Value), [turnoverdata[TBdate]], 0), [TurnoverData].Match(Me _
.CBOLineupdate.Value, [turnoverdata[CBOLine]], 0), [TurnoverData].Match(Me.CBOShiftUpdate.Value, [turnoverdata[FRMShift]], 0)).row
Print row

End Sub

 

[BobUmlas]

As a starter, Row is a keyword. Change it to Rw or Roww

 

[DanteAmor]

Try this

Private Sub find_Row_Click()
  Dim nRow As Long
  nRow = Evaluate("SUMPRODUCT((TurnoverData[Tbdate]=DATEVALUE(""" & Format(CDate(CBODateUpdate), "mm/dd/yyyy") & """))*" & _
                             "(TurnoverData[CBOLine]=""" & CBOLineupdate & """)*" & _
                             "(TurnoverData[FRMShift]=""" & CBOShiftUpdate & """)*ROW(TurnoverData[Name]))")
End Sub

 

[DanteAmor]

Also check this option:

Private Sub find_Row_Click()
  Dim nRow As Variant
  nRow = Evaluate("=MATCH(DATEVALUE(""" & Format(CDate(CBODateUpdate), "mm/dd/yyyy") & """)&""|" & CBOLineupdate & "|" & CBOShiftUpdate & """," & _
                   "TurnoverData[Tbdate]&""|""&TurnoverData[CBOLine]&""|""&TurnoverData[FRMShift],0)")
End Sub

 

[arcrazr]

The second option worked perfectly. Thanks!

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.