find a record

  • Thread starter Thread starter karim
  • Start date Start date
K

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
 
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
 
karim said:
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
Click to expand...
 
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....
 
Back
Top