You shouldn't need a query. If the form is bound to the table you can just put the table name in the row source.
On Tue, Aug 17, 2010 at 10:41 AM, Bruce Sorge <sor...@gmail.com> wrote: > > I created a query that selects the user ID adn user name from the table but > it only shows me one name in the combo box. I am sure that I am missing a > setting somewhere. > > On Tue, Aug 17, 2010 at 11:25 AM, Maureen <mamamaur...@gmail.com> wrote: > > > > > You should be able to go into design mode, right click on the text box > that > > contains the name, change it to a combo box. Open the properties window > and > > on the data tab set row source type to table/query and in the row source > > property select the name of the table. > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:325282 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm