"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."
Do you want the combo to show names but in actuality return the user id? If so, do the following: Create your source for the combo. It will probably be a query. The first column should be the user id, the next two column should be first and last name or last name and first name. Now, in the properties box for the combo box, there will be a field for the number of columns. Choose 3. You want to return all three columns from the query. Then, there should be a property for column widths. Set this to 0";1";1". This makes the first column invisible and shows the other two columns. In the table behind the form, the user id will be saved. Hope that makes sense. J - Experience hath shewn, that even under the best forms those entrusted with power have, in time, and by slow operations, perverted it into tyranny - Thomas Jefferson on government On Tue, Aug 17, 2010 at 1:44 PM, Maureen <mamamaur...@gmail.com> wrote: > > 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:325380 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm