Access 2007 Query Difficulty

I am having difficulty with a query in an Access 2007 database. I have created queries similar to the one I am having difficulty with in Access 2003 and everything worked fine.

I have a form that I want to use to run a query. On that form, I have a combo box linked to the customer name in my main table. Then I have a query, that I want to run after the customer name is filled in on the form. I want the query to get the customer name off the form and give me certain information from related tables regarding that customer. I have tried everything I can think of to get this to work. No matter what I do, I either get to many results, or not enough results.

I am attaching the database here, so that you can look at it. The query I am having trouble with is the one titled "Search". The form where the customer name should be entered is titled "Search Form". Any assistance you can provide would be greatly appreciated.

Avoid Spaces in Object Names!
See: The Ten Commandments of Access

Always follow then. Even when just testing or experimenting.


One issue:
Your combo box is bound to the column [MLA Number]. You query was using this to filter the [Customer Name] field.

Note: The [ ] are used because you have spaces in the names. Out of habit I type them when I see spaces in other peoples object names.. If you continue to uses spaces in the name you will need to learn this habit also.

I made some additional changes. See attached:

This is a duplicate thread to one where the answers were given.

Brian

Brianwarnock said:

This is a duplicate thread to one where the answers were given.

Brian

Click to expand...

It is true that the other post has some replies. I was not answered with a a "best practice" solution.

Boyd I was just trying to avoid 2 threads running in parallel.

Brian

Brianwarnock said:

Boyd I was just trying to avoid 2 threads running in parallel.

Brian

Click to expand...

Brain,

I totally agree with you. Keeping all the replies in a single thread sure makes following the thread a whole lot easier.

Keep up the great work!