Combo box filtering - Error 3341 Current field must match the join key '?'

[RhI098]

Hi, I'm trying to filter using cascading combo boxes, Responsible Technicican > Category > ItemID


The filtering appears to work but when I try to make the selection in the last combo box (ItemID) I get the following error
Table relationships look like this
Please help I dont understand the error

[Micron]

Haven't experienced this error, but a similar one. You don't really say which table the combos are bound to (e.g. ItemID is in 3 tables) but I suspect your issue is that you're trying to pick child values (the many) before you pick the parent value (the one side of the relationship). So I think Items.ItemID is the last combo. Also thinking that your form is based on a multi-table query which can raise this problem. In that case, changing your query join(s) to outer joins might help. A better approach may be a main form with subform(s).

[RhI098]

Thanks, correct all combo boxes are from Items table. These are in a subform based on LoanItems and Items tables. Ive tried changing the joins in the relationships but still getting the error. is this the same as query joins?

[Micron]

Ive tried changing the joins in the relationships but still getting the error. is this the same as query joins?

Not really. You could potentially use different query joins as long as they don't violate any relationships you've defined.

I'm not following why the controlsource (or are you saying recordsource?) for 3 combos are from the same table or query. The behaviour in your 1st post suggests the combos are bound (have a controlsource) yet you say you're filtering. You don't bind filtering combos. Nor would you ever pick the Primary Key (ItemID) from a combo (unless maybe it is meaningful data instead of an autonumber ID).

Responsible Technicican > Category > ItemID

Maybe all you have to do is remove the controlsource property to eliminate the error, but that still leaves me confused about the other things. So are you filtering records or creating/editing them?

Can you copy db, compact, zip and post the copy and include instructions on how to replicate?