WEB Query Not recognizing >>> [forms]![formname]![combobox]

[giorgospsk]

I have a web-db that works fine before i upload it to Sharepoint Server site.

the structure is pretty simple:

1 Table, 2 Forms, 2 queries.

The first form submits the data
The second retrieves the data,filtered by a query, which has a criteria controlled by a combobox....

so i choose the date from the combobox, and i press a button that runs the query and after that pops up a report...

the table has stored information about what chapters of courses have been tought every day, in a school.. (example : 2/12/2012 mathsage2 englishage4 chemistry:test1


i use the following criteria to the query :



=[Forms]![form that has the combobox]![combobox name]

and its ok.

BUT when i upload the db to the server , the following error occurs :

Invalid reference 'forms.orderbydate.combo' in expression.


If i updated the db without the query's criteria (the problem), i have normal access to the by the browser...


i wish someone could help me , ive tried EVERYTHING

[hertfordkc]

http://msdn.microsoft.com/en-us/libr...ice.11%29.aspx

It shows the syntax as not having brackets around Forms. I've had enough mystical results from object references that I'd take off the brackets before trying anything else.

[giorgospsk]

thanx a lot for the reply.
I admit i am a little bit confused with that. I have tried to change the syntax method, but it adds [ ] automatically. I am sure that the database after being published, cannot find or "see" where the [forms]![orderbydate]![combo106] is...
i think it is not bount at all...
is there a chance you know something about it??
thank you again.

[hertfordkc]

ask if there was anything in the database that was linked to your machine (as opposed to being imported into the database).

[giorgospsk]

well how do you mean "linked to" my machine?? like what could be linked to my machine??

sorry for my misunderstanding but english is not my mother language

[hertfordkc]

That is distinctly different from a database being contained in one package. Since such linkage requires a 'path', moving the database might conceivably require updating the linkage.
Please note that I haven't done anything like this since 1999, so this is speculation.