add blank value to a combo box (1 Viewer)

[campo88]

Hi

I have several combo boxes that uses a table as its values.

My last 2 combo boxes however need a blank value, which would be valid in this case. Can I easily insert a blank value to these combo boxes?

Thanks

 

[pbaldy]

You can just let the user leave it blank, or use a UNION query to join the choices from the table with a blank (Null or "").

 

[campo88]

how do i do this union query?

 

[pbaldy]

This type of thing:

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

 

[campo88]

Wooooaaah this is quite complicated for me. Can you help me write the code.

My row source type is a table/query and my row source code is:


SELECT ..............ORDER BY [Points].Option;

Can you tell me what I need to add to this code so I have a blank option available in my list?

Look forward to hearing from you.