How to print the result from a SQL command in acces
Posted on 2004-08-10
i have a combo box where I select card number.
Then on click I have a function "OnChange" that update some textbox corresponding to the selected card number.
like Me.TextZone1 = DoCmd.RunSQL "SELECT [description] FROM [division] WHERE [NoDeCarte]=" & Me.ComboBox & " LIMIT=1"
But I want the result of the query to be printed in the textbox