How to Set Row Source Type Like Value and Table/Query for ComboBox by Code

[chetu19800]

i need to add manual value by coding and also add name depended on queary how can set row source type are both value and table/query in combo box.

example :

i like add ALL and
other value fill by queary.

[Seth Schrock]

Here is a link to an article that tells how to get the "All Values" option. You can't do both value and table/query as the row source type, but you can build a UNION ALL query that has your manual values.

[chetu19800]

Lots of thanks dear this article is very help full ..

thanks for help dear.