Search results

I did. With the same result as before. I duplicated all the forms/subforms, and aliased the word 'Control' and it magically worked, indicating that the issue in fact tied directly to the name of the field/control.

I completely agree. Unfortunately, I don't have the ability to change the field names, as I'm a consultant on the project. I am however, thinking of another workaround based on the feedback here.

Thanks. I tried that also. The value is a text string, e.g. SJ134, so I pass it in single quotes. I surmise it may be a result of the field name of Control.

s So, I didn't develop the DB, I would not have used Control as a field name or object name anywhere in the DB. Control is the field name in the DB table, as such is the literally the pre-defined name of the "control" on the report I open, as well as the form I'm trying to open and filter...

Good day all, I am working on a VERY simple onClick Event in a report, then when clicked, should open a form to a specific record. (first time poster LONG TIME learner) Code is: Private Sub Company_Click() stcriteria = Me.Control.Value DoCmd.OpenForm "Clients", , , "[Control]='" &...

Isskint & BlueIshDan - 7ish years later, I came across this and it is exactly what I need for a project I'm working on. Thank you