I am trying to program an edit/delete button on a switchboard to open a certain policy number for editing etc. I know this is done through the properties, event procedure. But nothing is working. Please, please can I get the EXACT verbage to do this? This is what I already have tried and isn't working:
Private Sub OpenFormButton_Click()
Dim stDocName As String
Dim stLinkCriteria As String
Dim stPolicy as Variant
stDocName="tblBusAutoDec1"
stPolicy=InputBox ("Enter Policy Number?"
stLinkCriteria="[PolicyNumber]=" & stPolicy
DoCmd.OpenForm stDocName,,,stLinkCriteria
End Sub
Thanks soooo much!!!!
Jennifer
Private Sub OpenFormButton_Click()
Dim stDocName As String
Dim stLinkCriteria As String
Dim stPolicy as Variant
stDocName="tblBusAutoDec1"
stPolicy=InputBox ("Enter Policy Number?"
stLinkCriteria="[PolicyNumber]=" & stPolicy
DoCmd.OpenForm stDocName,,,stLinkCriteria
End Sub
Thanks soooo much!!!!
Jennifer