Hi All
I'm trying to run a query using docmd.openQuery. The query I want to run accepts 1 parameter which is located in the current form this is open in and running from. I tried doing something like this
but its not valid syntax. Any help would be gladly appreciated?Code:Private Sub Form_AfterUpdate() With DoCmd .SetWarnings False .OpenQuery (staffRecodUpdateTime [Form]![View Employee]!Text187.Value]) .SetWarnings True End With End Sub




Reply With Quote