The combo box should be bound to a query, "Like <criteria>", where
<criteria> is the same that you're using now, pulling the values from the
search form.
HTH
--
Rebecca Riordan, MVP
Seeing Data: Designing User Interfaces
Designing Relational Database Systems, 2nd Edition
www.awprofessional.com
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step
www.microsoft.com/mspress
"HandJT" <(E-Mail Removed)> wrote in message
news:7467AAB4-9725-4F8B-8D8B-(E-Mail Removed)...
> I have a search form where a user can search records within two tables
four
> different ways. When a user types in what they want to search with and
click
> search, it opens another form to display results. I have it working just
> fine, however if a user searches by let's say "DWG#" there could be more
than
> one record with that specific drawing number on it. So I added a combo box
> that lists the other records that this number is on. (The combo box lists
> numbers that are unique to each record.) Then, if the current displayed
> record isn't the one I want, I can click the down arrow button and click
on
> another record. The problem I'm having is that it won't list the other
> records. I'm missing some syntax code to list them. Can anybody think of a
> syntax code that I could use to list or add the records? Thanks a
million!!!
Similar Threads
