Connecting Tech Pros Worldwide Help | Site Map

Subform Search

  #1  
Old November 13th, 2005, 05:04 AM
TNGgroup
Guest
 
Posts: n/a
Hi,

I have a subform, In my list (subform) I have set a button to display the
data of that record into the form.
But I do not succeed in doing so.

Any help would be appreciated

TNGgroup

Code

Private Sub CmdTop

Dim RS as variant
Set RS = me.recordset.clone
Sfilter = "[frmTop].[Id] = '" & me![id] & "'"
rs.find Sfilter
if rs.EOF = True then
Msgbox "No info"
Else
me.bookmark = rs.bookmark
End if
RS.close
set RS = nothing
end Sub

Error
Run time error 3001




----------------------------------------------------------------------------
----



Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
filter a subform based on multiple multi select list boxes woodey2002 answers 1 March 1st, 2009 03:49 PM
Need to create a search facility suek answers 3 August 4th, 2007 07:05 PM
A2K: possibilities of adding snazzy search functions? Deano answers 5 June 18th, 2007 06:35 PM
Requery subform Kurt answers 14 July 5th, 2006 03:25 PM