Combo Box

T

Todd

When creating a combo box, can you combine two fields into the one field for
the combo box?

Thanks
Todd
 
W

WendyWest

Yes, you can concatenate words ([field1] & [field2]) or (field1] & ' ' &
[field]2) if you need a space between.
 
T

TedMi

To add some detail to Wendy's post: Make the row source of the combo box this
query:
SELECT [Field1] & [Field2] AS [GiveItSomeName] FROM [NameOfTable]

You could also add a WHERE clause if you want to filter the records from the
table.
 
Top