I am having trouble with something that I have never had problems with before.
I have a form with multiple unbound combo boxes. These are straight-forward: the only new thing I have used is that the second combo box has a query by form referring to the first combo box in order to limit choices by type: So, for example:
Cbobox1 = VesselName FROM Table/Query VESSEL DETAILS
Cbobox2 = TripId FROM Table/Query VESSEL TRIPS TABLE with Criteria on [Vessel] of FORMS!CatchTrendsSelectionForm!VesselName
This is all fine and works perfectly.
The issue is that the query which refers to this form in the criteria will not work. I have the criteria set up in the relevant fields in the qbe grid to refer to the relevant combo boxes in the form, but the query will not accept it - and gives me a "The microsoft database does not recognize FORMS!CatchTrendsSelectionForm!VesselName as a valid field name or expression" - UNLESS I enter it into the Query parameters as well.
I don't want to do that because hte resulting query is uploaded to Excel for charting and analysis and it the query won't export if there are query parameters attached to the query.
Does anyone know why I am getting this? I have numerous queries where I have queried by form in the same way and I have not had these difficulties. I can't see what I am doing wrong. BTW, all names are entered by selection, so it is not a question of spelling mistakes or incorrect references. Also btw, not trained in Access at all, I just bumble along...
Thankyou!