Search Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I've designed a database in order to search for specific data. What the
database stores is very simple information, such as first and last names of
couples to be married, and their wedding date and location.

Ive run into TWO problems:
1) If there are duplicate last names the search only comes up with the
result for the first entered name.
2) If there are multiple results for one last name, i need the ability to
scroll through the results.

Ive been trying on this one for awhile, and havent had any luck. Would
anyone be willing the check out the coding and possibily the entire database
to see wat exactly im doing wrong?

Thanks,
Matt
 
hi,
you didn't say how you were searching and scrolling so i
am assuming.
the only thing that comes to mind is the distinct word.
if in your select query you are using SELECT DISTINCT...
then you should change it to SELECT....
 
What are you using to return the records after the search is done? Are the
records (or record) being returned in a subform, a seperate form, etc? It
could be something as simple as changing the form properties to allow
navigation buttons. :-)
 
Back
Top