Trouble with opening form code

SD23

Registered User.
Local time
Today, 11:05
Joined
Jun 13, 2006
Messages
60
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 & "'")
 

Users who are viewing this thread

Back
Top Bottom