Access Web database on Sharepoint, Problem with Query Criteria

[giorgospsk]

I wish someone could help me on the following.
My target is to choose a value from a combobox (ok with that) so this value passes as a criteria to a web-query.(of my Access 2010 Web DB)
When I type in the criteria box
>>=[Forms]![formThatContainsTheCombobox]![NameOfComboBox]<<
the whole thing works ok. The query runs and the report is accurate.

If I published the db on my sharepoint site and access it, its is not working. It says
>>Invalid reference 'forms.orderbydate.combo' in expression.<<
. Ofcourse if i removed this expression the database is being displayed properly on the web but obviously the query returned all the records (and not filtered by my choise in the combobox).
I have tried many different combinations about the syntax of the expression but still nothin. on my pc it works fine , when i publish it, it's no.

I swear i've been infront of my computer more than three days due to this , so you can tell how useful an information would be.
Thank you ,
George

 

[Privateer]

giorgospsk,
When you reference a form Access fills in the name of the database because you can reference stuff in another database from the current one. My guess is that sharepoint needs the full name of the database then the form name. I am afraid I don't know the format for this, but you might try something like "C:\DATABASE\STUFF.ACCDB".[Forms]![formThatContainsTheCombobox]![NameOfComboBox].Value. Hope it helps.
Privateer