Select Query isn't working

[seanpbent]

So I have a select query with a criteria [Forms]![LookupForm]![Combo8] for field ProjectLocation. When the combo box is filled in and I run the query, it still asks me to input the parameter value separately. Every other time I've done this type of select query I haven't run into any problems. So, can anyone help me?

Also, I'm running Access 2013, not 2010.

[June7]

Usually means Access can't find the referenced item. Make sure names are spelled correctly.

I NEVER use dynamic parameterized query. I prefer to apply filter to forms and reports. Review: http://www.allenbrowne.com/ser-62.html

[seanpbent]

Everything is spelled correctly. I've checked like 100 times. Could it be anything else?

[June7]

Maybe. If you want to provide db for analysis, follow instructions at bottom of my post.

[seanpbent]

Okay, I did that and it worked. The relevant form is "LookupForm". The relevant queries are "Location_Lookup" and "Location_Select". The relevant tables are "Location" and "ER Log".

[June7]

Which query?

Can't test query because tables are linked and you did not provide backend. Again, if you want to ...

[seanpbent]

I don't have it linked to a change event yet. I've just been running the query manually.

[June7]

Which query?

[seanpbent]

Location_Lookup

[June7]

I give up. I tried deleting and recreating and renaming combobox. Only possibility I can come up with is corruption.

You have Location and [ER Log] tables linked on primary key fields. [Log #] must be unique in both tables. This means the tables have a 1-to-1 relationship. In which case, why bother with 2 tables?

I NEVER use dynamic parameter in query. I recommend using the WHERE CONDITION argument of OpenForm method - in macro or VBA.

Also recommend no spaces or special characters/punctuation (underscore is exception) in naming convention. Better would be LogNum or LogNo or Log_Num.

[seanpbent]

Alright, thanks for your help.