You can build a dynamic sql statement using a string: strsql = "Select field1, " & forms![formname]![InputControlName] & " from tablename;"
hope it helps -------------- Original message -------------- From: Beulah Florence <[EMAIL PROTECTED]> Can I perform a query using an input from the user as a field on which the query is written? It is very urgent. Please respond quickly if anyone can help. Florence A smile is the light in your window that tells others that there is a caring, sharing person inside.Keep SMILING. __________________________________________________________ Be a better Heartthrob. Get better relationship answers from someone who knows. Yahoo! Answers - Check it out. http://answers.yahoo.com/dir/?link=list&sid=396545433 [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
