Apparently the most difficult Access Web Database Question EVER!

[dreday]

I have searched for 3 days trying to find an answer to this and either I'm not phasing it correctly, it is simply impossible, or I'm the only person in the history or histories to ever try this. Access 2010 web database....



Combo box with a record source of a very simple query, something like:

Select clientID from tblClients

Instead of selecting the whole table, I would like to restrict the values by a value that I pass to the query either by macro or another field within the same form or a parent form, something that would look like this:

Select clientID from tblClients where agency = *[Passed value]*

Nothing works,
I've tried programmatically setting the Filter property of the query...ERROR
Modifying SQL code to reference a tempvar and a localvar....ERROR
I can't even reset the control source to a custom SQL

Is there anyway to solve this?

[TheShabz]

I'm not familiar with the web aspect of Access (frankly, I advise people to avoid using Access for web requirements) but your issue seems to be independent of that fact.

Where would your passed value be coming from? If it is another form control (and I assume you still have access to VBA), you can set the one of the event properties to
Me.comboBoxName.Rowsource = "SELECT clientID FROM tblClients WHERE agency = " & Me.ControlSourceWithAgencyName

[dreday]

Nope, no VBA in web databases, the saga continues

[TheShabz]

php/MySQL is your friend

[dreday]

Not an option so no help there

[dreday]

So there's no way to do this. Access won't let you set the control source of the combo box from the web. My workaround was to bind a form to a query and explicitly type a parameter so that when the sub form was opened it would restrict the values. Hope this helps anyone encountering the same issue.