Recent content by Spidergoy

Thanks Pat, I wish you were right. But no, access forces you to use the common subnavigation control instead of the specific subform name. if you use the real subform name it gives you an error. When you use the generator to let access build the reference, even if you select the a subform field...

Hi: I have the same problem but when I execute the code (asigning a value to the tab control) I get a message "Cant assign a value to this object". Why is this ?

The correct way to code the clause qdf.SQL = strSQL & "strWhere;" would be: qdf.SQL = strSQL & "'" & strWhere & "'" assuming the string strWhere has been defined somewhere.