What do I want: a list with filtered data (DBGRID), based on klantnummer (TxtTEST123.text). trying with:
sQlTekst = "Select BEZOEKEN.DATUM, BEZOEKEN.UUR, BEZOEKEN.CONTACT, BEZOEKEN.INFO, BEZOEKEN.INFORMATIE From BEZOEKEN WHERE BEZOEKEN.KLANTNUMMER = " & Val(TxtTEST123.Text)

when starting the program the DBGRID remains empty. When entering fixed data for example ("1250") the correct data will we displayed.

Who can help me to overcome those sleepless nightes?