View Single Post
  #2 (permalink)  
Old October 19th, 2005, 10:31 AM
mmcdonal mmcdonal is offline
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

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
Reply With Quote