Form Question

[dvannoy]

I am using the above code to open another form and goto the exact record that i am currently in....
Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "drum pad sampling sheet"

stLinkCriteria = "[ManifestNu]=" & Me![Manifest]
DoCmd.OpenForm stDocName, , , stLinkCriteria

but there could be a "CONT" after the manifestnu....so i am trying to open up evrything that relates to the current record i am on...(e.g. if i am on #12345-1A there could also be 12345-1a-cont as well...) I have tryed putting the "LIKE" * & in front and behined manifestnu and it does not work...also tryed " " & manifestnu & " " and it also did not work....

can anyone help me??
thanks in advance

 

[Aivars]

Hi!
Apparently [ManifestNu] is text type field. If it's so you must use quote marks:

stLinkCriteria = "[ManifestNu]='" & Me![Manifest] & "'"

Aivars