C campo88 Registered User. Local time Today, 08:30 Joined Nov 20, 2009 Messages 46 Dec 25, 2009 #1 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
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 Wino Moderator Staff member Local time Today, 00:30 Joined Aug 30, 2003 Messages 36,270 Dec 25, 2009 #2 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 "").
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 "").
C campo88 Registered User. Local time Today, 08:30 Joined Nov 20, 2009 Messages 46 Dec 25, 2009 #3 how do i do this union query?
pbaldy Wino Moderator Staff member Local time Today, 00:30 Joined Aug 30, 2003 Messages 36,270 Dec 25, 2009 #4 This type of thing: http://www.mvps.org/access/forms/frm0043.htm
C campo88 Registered User. Local time Today, 08:30 Joined Nov 20, 2009 Messages 46 Dec 25, 2009 #5 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.
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.