how to add select all option in combo box

[vaibhav2015]

Hi,
I have created Form with 2 combo box. I want to add "select all" option in combo box. Please advice how I can add the option.

 

[namliam]

No need to post the same question two times

Please continue here: http://www.access-programmers.co.uk/forums/showthread.php?t=281205

 

[vaibhav2015]

sorry, deleted other question.

 

[pbaldy]

Here are a couple of ways:

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

 

[vaibhav2015]

Hi,
I tried that and create below union query and I can see list of plants in combo box. but I am not able to get select all option .

SELECT [plant2] & "All" FROM [ACT_Sub_table] UNION SELECT [Plant] FROM [Plant data ACT table];

 

[pbaldy]

Try

SELECT "All" As Plant FROM [Plant data ACT table] UNION SELECT [Plant] FROM [Plant data ACT table];

 

[vaibhav2015]

Hi,
I have tried above union query but I got error message " The value you entered isn't valid for this field."
Plant column is short text.

Please advice.

 

[arnelgp]

SELECT "All" FROM [Plant data ACT table] UNION SELECT [Plant] FROM [Plant data ACT table];

 

[vaibhav2015]

thanks I tried that but I got same error message again.
Do I need to add "All" word in table ?

 

[arnelgp]

no , you put this in your combo/listbox Row source.

 

[vaibhav2015]

ok thanks , If have plant column in Number format, then how I can write union query.

Please advice.

 

[arnelgp]

just the same, but on the resulting query after the union your Plant column will be coverted to string.

 

[pbaldy]

Is there also a description field? You could do:

SELECT Null As Plant, "All" As Description FROM [Plant data ACT table] UNION SELECT [Plant], PlantDesc FROM [Plant data ACT table];