Did you get the answer? Add a user prompt to the query. select * from employees where employee name = [EnterName]
will prompt for a name. Regards, Mark Bartnik >From: Beulah Florence <[EMAIL PROTECTED]> >Reply-To: [email protected] >To: [email protected] >Subject: [Access VBA Central] Field Level Queries >Date: Thu, 28 Jun 2007 02:51:47 +0530 (IST) > >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] >
