CODEWITHSUNDEEP
ms-access
Chuck0185
Chuck0185

Reputation: 531

MS Access Combo Box Row Source: Looking to get values from a table but also add a single value that is not in the table

I have a combo box on one of my forms. I would like the row source to pull from a field in a table that I have. I have that working fine. However, I would like to add one value that would not be in the table itself. So basically I am looking to offer all of the values in the table field plus one that I would not have to add to the table.

Upvotes: 0

Views: 327

Answers (1)

O. Gungor
O. Gungor

Reputation: 768

you can't do both. but you can modify the underlying query to append that one value you want included in a union

SELECT column1, column2
FROM yourtable
union all
select top 1 'x','y' 
FROM yourtable

Upvotes: 1

Related Questions