E
Emanuel Violante
Hi everyone,
I hope that anyone can help me....
I'm trying to run the following code, but i get an type mismatch error
message.
If I use the stlinkcriteria or stlinkcriteria2 in the where condition, it
works fine, but i would like the command button to perform the two conditons
Dim stDocName As String
Dim stLinkCriteria As String
Dim stLinkCriteria2 As String
Dim stWhere As String
stDocName = "sintese_frs"
stLinkCriteria = "[gt_index]=" & "'" & Me![gt_index] & "'"
stLinkCriteria2 = "[out2_design]=" & "'" & Me![out2_design] & "'"
stWhere = stLinkCriteria And stLinkCriteria2
DoCmd.OpenForm stDocName, , , stWhere
--
Thanks,
Sorry if my english isn''t correct, but I''m from Potugal
Emanuel Violante Galeano
I hope that anyone can help me....
I'm trying to run the following code, but i get an type mismatch error
message.
If I use the stlinkcriteria or stlinkcriteria2 in the where condition, it
works fine, but i would like the command button to perform the two conditons
Dim stDocName As String
Dim stLinkCriteria As String
Dim stLinkCriteria2 As String
Dim stWhere As String
stDocName = "sintese_frs"
stLinkCriteria = "[gt_index]=" & "'" & Me![gt_index] & "'"
stLinkCriteria2 = "[out2_design]=" & "'" & Me![out2_design] & "'"
stWhere = stLinkCriteria And stLinkCriteria2
DoCmd.OpenForm stDocName, , , stWhere
--
Thanks,
Sorry if my english isn''t correct, but I''m from Potugal

Emanuel Violante Galeano