Search results
-
L
I can't find the Type Mismatch
Okay, I just noticed something interesting, but I may need a little help to automate this. As I said, it works now but only shows a detail form for the first record. However, I noticed that if I click on the ClaimID text box in a different record, the link does execute properly. Is there a...- Lucantha
- Post #8
- Forum: Modules & VBA
-
L
I can't find the Type Mismatch
Pete, I changed the Select Case statement to match yours: Select Case Me.Cl_Type.Value Case "Auto" strFrmOpt = "Auto_Claim_frm" strIDr = "Auto_adjID" Case "GL" strFrmOpt = "General_Liability_Claim_frm" strIDr = "GL_adjID"...- Lucantha
- Post #7
- Forum: Modules & VBA
-
L
I can't find the Type Mismatch
Hmm... I added it, but nothing has changed.- Lucantha
- Post #3
- Forum: Modules & VBA
-
L
I can't find the Type Mismatch
I have a form that I placed a "link" to which is supposed to open one of three forms dependent on a value on the form. This is the sub: Private Sub Label46_Click() On Error GoTo Err_Label46_Click Dim stDocName As String Dim stLinkCriteria As String Dim strFrmOpt As String Dim...- Lucantha
- Thread
- Replies: 7
- Forum: Modules & VBA
-
L
Convert Text box value to link?
Hello, I'm new to this forum and relatively new to Access, so this may be a rudimentary question but I ask nonetheless. I have a form that lists records in a report style format based on either all records or an automated filter. What I want to do is make one of the identifying controls (in...