DoCmd.FindRecord ends at last record

[internetintern]

hello,

I have a code like:

Private sub button1_Click()
DoCmd.FindRecord Me.fieldname.Value, acStart, , acSearchAll, , , False
end sub

but the problem is that the command stops searching at the last record. so the records before the current record are not searched. I thought with acSearchAll it should search the entire record list.

I need some help here.

[Plater]

I don't know what object you are using, but DataReader can only be searched through once.

[internetintern]

I am working with Ms access forms and the code above is a control for a button. I don't want to start searching from the first record (this works fine). the docs show that the above code should search from the current record to the end of the set, then start from the beginning to the current record. in the end all records should be searched. I don't know why this doesn't work for me.

I may have posted this question in the wrong place

[Plater]

So this is VBA? I will move it then.

[NeoPa]

Thanks Plater :)

Try :

Call DoCmd.FindRecord(FindWhat:=Me.FieldName, _
                      Match:=acEntire, _
                      Search:=acSearchAll, _
                      OnlyCurrentField:=acCurrent, _
                      FindFirst:=True)

Please let us know if this works for you.

[internetintern]

yes it is vba, thanks for moving it; i tried to figure out how to do it.

thanks NeoPa for the code. it begins always from the first record. also it would always find the first hit. My code begins from the next record after the current record and should cycle through the entire record set back to the current record just like the Access 'Find Next'.

I'm still trying to find out why it ends at the last record instead of continuing from the first record back to the current record.

[NeoPa]

I looked in Help & it says little more than listing the available values for the parameters. Essentially, it's not a lot of ...

Anyway. I suggest your next step is to experiment with the three parameters (Match, Search & FindFirst) to see if you can come up with a combination that does it as you need. Unfortunately, it is sometimes necessary to do some research (in this case trial & error) before being able to understand things correctly.

[internetintern]

I couldn't get the docmd.findrecor d to work like I wanted so I implemented my own search over the recordset.

Thanks for your suggestions.

[NeoPa]

That seems like a shame. Sorry I couldn't be more help.

A self-made search should only be noticeably slower if the number of records is quite large though.