That can be done, I just don't have an access database available for you to look at.
I think in the form designer you select a drop down list as your tool and then you go the the properties of it, where you can specify a query to populate the ddl. Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC 29576 843-357-1847 http://www.showstopperonline.com -----Original Message----- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 11:10 AM To: CF-Community Subject: Access form question I am designing a form in access and need it to do as follows. I need to have a query that is run that makes it so a drop down list is part of records that will be inputted into a database. For my needs it will be a list of charges that will be a drop down. They select the charge, then how much we will charge them, then either insert or go to the next record. Is there anything like this? Maybe some examples I can look at? Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=5 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
