Locopete99
Registered User.
- Local time
- Today, 11:04
- Joined
- Jul 11, 2016
- Messages
- 163
Hi Guys,
I have 2 sub forms. One subform for showing new work and one for outstanding.
Both subforms are hyperlinks with the below code to enable the user to open up the form they relate to.
Both have this code on Click on the text box.
The outstanding sub form is working, but the "new" subform give mes the error
"The expression On Click you entered as the even property setting produced the following error: A problem occurred while database was communicating with the OLE server or ActiveX Control."
*All table fields relating to this match.
*Both codes are the same.I basically copied and pasted the code from one subform to the other as it was doing the same job.
*Both are in the same event - on click, but on their respective forms and textboxes
*Both sets of text boxes are set as hyperlinks.
* I have even moved the same test data from New to outstanding and back, so that i was testing with the same test data.
What am I missing that this would work on one but not the other? I can't see anything and i'm at my whits end.
I have 2 sub forms. One subform for showing new work and one for outstanding.
Both subforms are hyperlinks with the below code to enable the user to open up the form they relate to.
Code:
DoCmd.OpenForm "Frm_logRequest", acNormal, , "ID=" & Me.IDBoth have this code on Click on the text box.
The outstanding sub form is working, but the "new" subform give mes the error
"The expression On Click you entered as the even property setting produced the following error: A problem occurred while database was communicating with the OLE server or ActiveX Control."
*All table fields relating to this match.
*Both codes are the same.I basically copied and pasted the code from one subform to the other as it was doing the same job.
*Both are in the same event - on click, but on their respective forms and textboxes
*Both sets of text boxes are set as hyperlinks.
* I have even moved the same test data from New to outstanding and back, so that i was testing with the same test data.
What am I missing that this would work on one but not the other? I can't see anything and i'm at my whits end.
