p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Access (http://p2p.wrox.com/forumdisplay.php?f=18)
-   -   combo box with 2 columns (http://p2p.wrox.com/showthread.php?t=34415)

mjuliao October 18th, 2005 11:09 PM

combo box with 2 columns
 
i am using a combo box with 2 columns but when i select a choice it only shows the first column value, i want to show the 2 columns selected

thanks


mmcdonal October 19th, 2005 10:31 AM

The way I would do this (and I have) is to modify the query behind the combo box. If the two fields are LastName and FirstName, for example, modify the query like this:

Add a column to the query called "Name" and put this as the source:

Name:([LastName] & ", " & [FirstName])

Then hide those two columns by unchecking show column.

Then modify the combo box to 2 fields (PK and Name) and change the display to something like 0";2"

HTH

mmcdonal


All times are GMT -4. The time now is 10:40 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.