Search results

  1. M

    SQL Query on a combo box

    Finally, I found a (complicated :() solution to the problem: First, I created a new blank query, called qryParticipantsBkp, and in the SQL view I wrote this: SELECT * FROM qryParticipants then, in the VBA code inside the parent form, when launching my new form I wrote this: Dim dbs as...
  2. M

    SQL Query on a combo box

    I'm sorry, but it's not working :( I've tried to insert & " at the end of the code too, along with every combinations of brackets and " but the WHERE clause is not processed yet. I'm very confused about it... :confused:
  3. M

    SQL Query on a combo box

    Yes, is correct. On the form I have a control called ID_Edition, and is an integer (Auto Number), used as index key in the originating table.
  4. M

    SQL Query on a combo box

    Hi everybody, I have a problem with a SQL statement in a combo box. I have the following query, called qryParticipants, originating from four different tables, linked in a relationship: ID_Course; Course Title; ID_Edition; ID_User; Surname; Name In my combo box I want to display only...
Back
Top Bottom