find a record

[karim]

Hi All,
I have a find a record button. It works fine if there is one entry in
the date field, but if there is more than one entry on the same date, it just
get stuck on the first record and it would not allow you to pick any other
record from that date. If you pick a different date, it work fine.... Any
ideas on this issue would be apperciated.

Thanks

 

[techrat]

If the find button is using docmd.findrecord, you may want to look at
the FindFirst parameter. See the following excerpt from the help
screen:

Find First Specifies whether the search starts at the first record or
at the current record. Click Yes (start at the first record) or No
(start at the current record). The default is Yes.

This combined with the Search (Direction) parameter will allow you to
control the behavior of the search.

HTH

 

[Vanessa]

Hi All,
I have a find a record button. It works fine if there is one entry in
the date field, but if there is more than one entry on the same date, it
just
get stuck on the first record and it would not allow you to pick any other
record from that date. If you pick a different date, it work fine.... Any
ideas on this issue would be apperciated.

Thanks

 

[Jerry Whittle]

What is the code behind the Find button?

 

[karim]

There is no code. I have a macro that search for a record and it find out the
first, last, next, previous record, but no current record or exact record. so
if you have a vba code that would help fix the problem, that would be great.

Thanks....

 

[Tom Wickerath]

Hi Karim,

This sample, available as a download from my web site, might be helpful for
you:

http://www.accessmvp.com/TWickerath/downloads/customdialogbox.zip


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________