Search Form Problems

K

Kgwill85

I have a form that has two fields in it. The first field is for a ID
number, and the other is for the projects name. I am having a problem
with using the form for as a search tool.

Some of the values are duplicates in the drop down, I wanted to know
how to properly filter the combo box so that the values can only be
seen once.

The Row Source is the name of the table that the fields are from,
however this only words for the ID combo box and not the project name
one. For some reason the values are from the ID column in the project
name's combo box as well. To counter this problem, I simply made a
query that pulls the information from the project name field in the
original table.

I have written a macro that tells the form to find the record that is
chosen or entered in the combo boxes. When you click the search
button on the form it goes to another form that the rest of the
information is in. I got this to work for the ID combo box fine. The
problem has been the project name. When I search for the project name
the form comes up with an error message. I have no clue why this task
is so complicated when the ID information works fine.

Anybody know how I can fix this problem?
 
Top