add blank value to a combo box

campo88

Registered User.
Local time
Today, 08:30
Joined
Nov 20, 2009
Messages
46
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
 
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 "").
 
how do i do this union query?
 
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.
 

Users who are viewing this thread

Back
Top Bottom