Hello,
I'm having an issue trying to load a form based on 2 text boxes. Here is the code I'm currently using:

    Dim stDocName As String
    Dim stLinkCriteria As String
    Dim stLinkCriteria1 As String

    stDocName = "frm_Prod_Entry"

    stLinkCriteria = "[Date]=" & "#" & Me![Combo11] & "#"
    stLinkCriteria1 = "[Shift]=" & "'" & Me![Combo16] & "'"

    DoCmd.OpenForm stDocName, , , stLinkCriteria And stLinkCriteria1

I receive a type mismatch error I believe because the And is putting the two together. Is there a way to use two variables to load a specific form record?

Thanks,
Andy

Hi,

Dim stDocName As String
    Dim stLinkCriteria As String
    Dim stLinkCriteria1 As String

    stDocName = "frm_Prod_Entry"

    stLinkCriteria = "[Date]=" & "#" & Me![Combo11] & "#"
    stLinkCriteria1 = "[Shift]=" & "'" & Me![Combo16] & "'"

    DoCmd.OpenForm stDocName, , , stLinkCriteria & " And " & stLinkCriteria1

Peko

Hi,

Long time Access user (self-taught)

I just wanted to say thanks:

---to Andy for posting the problem which was similar to mine
---to Peko for the posting the solution

I spent 4 solid hours rearranging punctuation, saving, trying, etc.
None of my books even list the term "stLinkCriteria" in their indexes!

I was trying to use 2 criteria w/o the second stLinkCriteria1 and w/o the " " around the And operator. I swear that I have not had to use this in past similar circumstances.

Much appreciated.

Greg M.