N noccy Registered User. Local time Today, 09:33 Joined Aug 19, 2003 Messages 67 Aug 19, 2003 #1 Hello How can I diaplay the result of an SQL-string in a txt box let's say my SQL is SELECT Adress FROM People WHERE Name = "Smith" and my txt box is txtAdress suggestions?
Hello How can I diaplay the result of an SQL-string in a txt box let's say my SQL is SELECT Adress FROM People WHERE Name = "Smith" and my txt box is txtAdress suggestions?
Mile-O Back once again... Local time Today, 09:33 Joined Dec 10, 2002 Messages 11,316 Aug 19, 2003 #2 An SQL statement doesn't return a result - it returns a recordset. You probably want to look up the domain aggregate functions most notable, DLookup() in the help files.
An SQL statement doesn't return a result - it returns a recordset. You probably want to look up the domain aggregate functions most notable, DLookup() in the help files.
N noccy Registered User. Local time Today, 09:33 Joined Aug 19, 2003 Messages 67 Aug 19, 2003 #3 tnx solved it =)
