Search a different table

[PharmaFun]

Hello,
I have this code here for searching a table tied to a form, and returning the entry that matches the search number. The code is below. How can I search an entry in a table no linked to the form? I've tried changing "[Number]" to "[Initial Patient Report].[Number]" to reflect the fact that I want to search the table "Initial Patient Report." Any ideas?

Thanks,
Dino

Private Sub cboSearchID_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[Number] = " & Str(Me![cboSearchID])
Me.Bookmark = rs.Bookmark
Me.cboSearchID = Null

End Sub

 

[Rolliee]

Dino,

Remember how you have to present text numbers?

rs.FindFirst "[Number] = '" & Str(Me![cboSearchID]) & "'"



Rollie E

Remeber also troops that if a tip is of value to click the button above that says so.

 

[Rolliee]

Did you catch the apostrophies above?????