combo box : record source & list values

[NOL]

is it possible to have a combo box display values from a query AND list values ?
e.g. I have a query [Status] which has values '123', '234', '1234'

can i have the rowsource of my combox as :
select * from [Status]; 'All'


Thanks for anny help in advance,
Gina

 

[mission2java_78]

Yes this is possible:
Me.Combo0.RowSource = "SELECT [Query1].[Test] FROM Query1 UNION SELECT 'ALL' As Test FROM Query1"

Will add "All" to a combo boxes rowsource...you can place this code behind the form load event or some event or do it dynamically via code.

Jon

 

[NOL]

Now isn't that SMART!!!
thanx so much!