G Guest Dec 29, 2005 #1 When creating a combo box, can you combine two fields into the one field for the combo box? Thanks Todd
When creating a combo box, can you combine two fields into the one field for the combo box? Thanks Todd
G Guest Dec 29, 2005 #2 Yes, you can concatenate words ([field1] & [field2]) or (field1] & ' ' & [field]2) if you need a space between.
Yes, you can concatenate words ([field1] & [field2]) or (field1] & ' ' & [field]2) if you need a space between.
G Guest Dec 29, 2005 #3 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.
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.
