Form/Combo box parameter issue.

[Bmo]

I have one form and 4 queries.

qry_part1
qry_part2
qry_sched
qry_join

frm_categoryselection

I have 2 combo boxes on the form that have the categories loaded in from a query out of the table that houses all the categories.
cmbo_part1
cmbo_part2


in qry_part1 the criteria is to just give me the info for those categories

[Forms]![frm_categoryselection]![cmbo_part1]

in qry_part2

[Forms]![frm_categoryselection]![cmbo_part2]

qry_join adds those two table together to give me the schedule with the part number the model takes that I have selected. If I select the motor and harness categories I should get the schedule with the part number that model takes for the harness and motor. It worked earlier today, I changed some thimgs but nothing that I thought would have been in this process but I evidently changed something on accident.

I have a button that executes qry_join, at which point it propmpts for a parameter for "[Forms]![frm_categoryselection]![cmbo_part1]" and
"[Forms]![frm_categoryselection]![cmbo_part2]" when it should be just taking that value from my form.

What the H. It worked fine yesterday. I haven't changed anything major and now I cant get that link back together. Can anyone help me?

[maximus]

Have you change the name of the comboboxes. Check that please.

[Bmo]

I hadn't initially, then I went through and changed everything. I used the builder to stave off any syntax/spelling errors. Then I changed it all back, being extra careful.

I've even tried putting a new combo box on the form and trying to link it to that one in case I buggered up the default settings on the ones on the form already and broke it that way to no avail.

I believe this project has become sentient and is trying to break my spirit!