I resolved the Issue but I am not sure how. All I did was stare at the single line of code cursing access.
Oh yeah I recompiled it and it ran.
Thanks
User Profile
Collapse
-
Actually This is the only place in the app where the OpenForm command fails. But I will try what you stated and see what happensLeave a comment:
-
Off the top of my head I would say that the problem is in the .WTG = )) portion of the SQL. There does not appear to be a value in the right side of the testLeave a comment:
-
DoCmd.Openform Fails on dual Proc Machine
Access 2002-2003 runtime
App works fine on single proc machines but we are rolling out a tech refresh and we found this case where the code appears to simply slip through the open form command and the form never opens.
If Not IsNull(frmPODet ails.Form!txtPO Number) Then
MsgBox "frmPurchaseOrd ers Open Form"
DoCmd.OpenForm "frmPODetailsUn bound"
...
No activity results to display
Show More
Leave a comment: