ComboBox Recordsource -- SQL and static list

[tylerg11]

Hello,



I would like to set the RecordSource of my combobox to be based on a SQL statement/Query. But I also have two additional values that are always "static". So I basically want a combination of the SQL statement (dynamic) and a list of values (static). Any way I can do this programmatically?

[pbaldy]

Presumably you mean row source. You can do this:

http://access.mvps.org/access/forms/frm0043.htm

or put the values in a table.

[tylerg11]

Yes, that works. Thanks.

[pbaldy]

No problemo.