Combo box not displaying properly

[Bagels]

I'm pretty sure i'm off conceptually here....need a little help.



I have a database that manages customer returns (RMA's)

I want a form that has 2 combo boxes (cascading) where the user selects a customer from the first one, then the 2nd returns all the part numbers associated with that customer, the user selects a part number, and a RMA report is generated for it.

For the first one, i have a query as the row source:
SELECT DISTINCT PartNumbers.Customer
FROM PartNumbers
ORDER BY PartNumbers.Customer;

when I run the query, it works correctly. But when I open the form, the combo box is blank. I'm pretty sure the bound column setting is correct. Im guessing i have the control source wrong , or maybe some settings on the form itself?

[Welshgasman]

No, that is the way it works if the control is unbound?
If it was bound then it would show the value from the record.

However, you would have to put a value into the record first?

Sounds like you do not need bound combos anyway, as you just want to generate a RMA. If you want to keep track of the RMAs generated, then yes, they could be bound.

Unbound is a bit like having search controls.?

[Bagels]

I want a form where the user selects 3 things: customer, then part number, then date range.

Then a summary report for all RMA's for that part number and date range is generated.


The queries all seem to function correctly when I run them within the query design, so there's obviously something i'm doing wrong within the form


Right now I have individual reports for each customer and its ok, I just wanted to clean it up and make it so that it's just 1 form where the user selects all the parameters.

[Welshgasman]

Well it sounds like you are not storing the report requests, so all 3 controls can be unbound?
If you already have individual reports, then you must have the customer criteria? Just need to add partnumber and date range to the criteria.

Of course, this assumes you have all that in the source for the report?

Why not show what you are trying to run?, within code tags please.

[Bagels]

That's an example of a query/report for a specific customer (Jackson)
I just want a form where instead of it being for a specific customer, the user selects the customer from a drop down instead.

[Welshgasman]

Ok,
The easiest way I would do this from what you have is change the starting/ending date to compare against the form controls, the customer from a TempVar as that value is in a combo column, same with partnumber.
If I did not want to tie that report to just that form, I would use TempVars for all the criteria, which is what I would normally do anyway.

I would also not be using the customer name, but their customerID. What if you have two Jacksons?