Explain vba search code

[Beany]

I managed to find a search example on the forum but i dont understand the following code properly........

can someone explain this to me:

Private Sub QuickSearch_AfterUpdate()
 
DoCmd.Requery
Me.RecordsetClone.FindFirst "[provider] = '" & Me![QuickSearch] & "'"
If Not Me.RecordsetClone.NoMatch Then
   Me.Bookmark = Me.RecordsetClone.Bookmark
Else
   MsgBox "Could not locate [" & Me![QuickSearch] & "]"
End If
 
End Sub

thanks

[missinglinq]

Private Sub QuickSearch_AfterUpdate()
'Reruns the query the form is based on
DoCmd.Requery
'Goes to a record where the field provider is the same as the value in the control QuickSearch
Me.RecordsetClone.FindFirst "[provider] = '" & Me![QuickSearch] & "'"
'If a match is found a bookmark is set to the record
If Not Me.RecordsetClone.NoMatch Then
Me.Bookmark = Me.RecordsetClone.Bookmark
'If no match is found a messagebox popsup to report the failure
Else
MsgBox "Could not locate [" & Me![QuickSearch] & "]"
End If

End Sub

If a match is found, the bookmark will cause the appropriate record to be displayed.

[Beany]

thanks for that...........

what are the errors that you can get when you use this code?

im using this code for my search form but im having problems with the following line:

Me.RecordsetClone.FindFirst "[provider] = '" & Me![QuickSearch] & "'"

why do u think that is?

[missinglinq]

What problems/error codes are you getting? Is the field you're searching on named provider? Is the text box you're entering your search string in named QuickSearch! Otherwise, the code won't work!

[MMcCarthy]

thanks for that...........

what are the errors that you can get when you use this code?

im using this code for my search form but im having problems with the following line:

Me.RecordsetClone.FindFirst "[provider] = '" & Me![QuickSearch] & "'"

why do u think that is?

Me.RecordsetClone gets all records currently bound to a form and puts them in a recordset. If your search form is not bound to a table or query it won't return anything.

Mary

[Beany]

Me.RecordsetClone gets all records currently bound to a form and puts them in a recordset. If your search form is not bound to a table or query it won't return anything.

Mary

Ok,
the error that i am getting is the following:

Run-time error '7951';

You entered an expression that has an invalid reference to the RecordsetClone property.

and it takes me to the code part which i mentioned in my previous post.

y is that?

[MMcCarthy]

Ok,
the error that i am getting is the following:

Run-time error '7951';

You entered an expression that has an invalid reference to the RecordsetClone property.

and it takes me to the code part which i mentioned in my previous post.

y is that?

Is your form bound to a table or query?

[Beany]

Is your form bound to a table or query?

Its bound to a query qry_all_details.

what i have is a textbox that has another text box underneath it....

in the first text box i enter the providers name and it lists all the details in the second text box (in order of the provider - just showing the provider i searched for)

if i dont type in anything in the first textbox..... it just shows a list of all details in the second textbox(from qry_all_details)..........

what i want to do also is, by selecting the provider in the second textbox, i want it to bring up all the details in a form style on the same page(possibly below the two textboxes)....... how do i do it???

but firstly how do i rectify the error im getting?

[NeoPa]

Try

Debug.Print "[provider] = '" & Me![QuickSearch] & "'"

before your line that searches for it and post the results (Copy from immediate pane - Ctrl-G to get there).