Not sure what is wrong with my code. I am trying to open a form based on the siffix and prefix. It just opens up the first form created. They are both text fields. Any suggestions would be appreciated. Thanks.
Dim stLinkCriteria As String
Dim strdsuf, strdpre As String
strdsuf = Me.dsuf
strdpre = Me.dpre
stLinkCriteria = "[Docket No Prefix] = '" & strdpre & "'" & " And [Docket No Suffix] = '" & strdsuf & "'"
DoCmd.OpenForm "Dockets Data Input Form", , , ("[Docket No Prefix] = '" & strdpre & "'" & " And [Docket No Suffix] = '" & strdsuf & "'")
Dim stLinkCriteria As String
Dim strdsuf, strdpre As String
strdsuf = Me.dsuf
strdpre = Me.dpre
stLinkCriteria = "[Docket No Prefix] = '" & strdpre & "'" & " And [Docket No Suffix] = '" & strdsuf & "'"
DoCmd.OpenForm "Dockets Data Input Form", , , ("[Docket No Prefix] = '" & strdpre & "'" & " And [Docket No Suffix] = '" & strdsuf & "'")