Row Source: query and fixed value 2

[colossalUW]

Hi all,

I can't seem to figure this out or find a thread on it...

Is there a way to have a combo box row source based on a query AND have a fixed value?

For instance, I want the first selection choice in the combo box to be "UNKNOWN", and every subsequent choice to come from a query.

Thanks much!

 

[PHV]

Have a look at UNION query.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[TheAceMan1]

How are ya colossalUW . . . . .

Have a look here (substitute 'All' with what you like): How to add '(all)' to a combo box or a list box

See Ya! . . . . . .

 

[colossalUW]

Thanks PHV and AceMan! I ended up creating a union query and setting it as the Row Source - works great.