Combo Box problem

[PE]

I have two tables in a database - Guests and Bookings. Guests table has
Title, Initials and LastName fields.

In Bookings form I have inserted a combo box which shows the guest names
from Guests table in a drop down list starting with the LastName and
followed by Title and Initials. When I select a name only the LastName
appears in the form. Is there a way of inserting the guest name on the
form in the order Title, Initials and Lastname as this is how I would like
the name to appear in reports produced from the Bookings Table/Form. By the
way, guest names in the Bookings table can be any name and not limited to
the list.

Your help would be much appreciated.

Al

 

[Bob]

You could create a two-column combobox. The first would be
the bound column that is stored in the Bookings
table...probably GuestID (Don't display it in the
combobox). The second would be an expression. Something
like:

MyDesiredResult: [Title] & " " & [Initials] & " " &
[LastName]

You can sort the data in the combobox by LastName by
adding it to the query and selecting a sort option.
Unselect it to show in the combobox results.

Set the column count to 2, the bound column to 1 and the
column width to 0";YourDesiredWidth.