Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Switchboard Button Programming
- Thread starter murk
- Start date
Try the following:
Private Sub OpenFormButton_Click()
Dim stDocName As String
Dim stLinkCriteria As String
Dim stPolicy as Variant
stDocName = "frmNameofForm"
stPolicy = InpuBox "What is Policy Number?"
stLinkCriteria = "stPolicy =" & Me![PolicyNumber]
DoCmd.OpenForm stDocName, , , stLinkCriteria
End Sub
Private Sub OpenFormButton_Click()
Dim stDocName As String
Dim stLinkCriteria As String
Dim stPolicy as Variant
stDocName = "frmNameofForm"
stPolicy = InpuBox "What is Policy Number?"
stLinkCriteria = "stPolicy =" & Me![PolicyNumber]
DoCmd.OpenForm stDocName, , , stLinkCriteria
End Sub
- Status
Similar threads
- Locked
- Question
- Locked
- Question