Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    110

    Unanswered: Persistent type mismatch

    Hello everybody

    I am trying to write an SQL query. The code is

    strSelect = "Select * From EPISKEYH WHERE Kwdikos_texnikou =" & CStr(Me.Kwdikos_texnikou)
    Set rsEpiskeyes = CurrentDb.OpenRecordset(strSelect)

    where
    strSelect is a String
    EPISKEYH.Kwdikos_texnikou is a Text(4)
    Me.Kwdikos_texnikou is a text box on a form

    When the OpenRecordSet function is called I get a type mismatch. What am i not doing correctly?

    thx, in advance

    George Papadopoulos

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Try
    strSelect = "Select * From EPISKEYH WHERE Kwdikos_texnikou = '" & CStr(Me.Kwdikos_texnikou) &"'"

    See the red symbols

  3. #3
    Join Date
    Apr 2004
    Posts
    110
    thx, it was a syntax error after all.

    Great!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •