Link to home
Start Free TrialLog in
Avatar of bkapla1
bkapla1

asked on

Assign "None Selected" in combobox

I expect this to be easy, but can't seem to figure it out.

I have a combobox that uses a query for it's recordsource.  How can I add a value to the combolist that states "None Selected."  I want this value to appear as the default when the form is opened as well as be a selection within the drop-down.  However, I do not want to physically add this as a value to the table.

The VBA will capture the logic handling based on the selection.

Thanks!
ASKER CERTIFIED SOLUTION
Avatar of bluelizard
bluelizard
Flag of Switzerland image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of bkapla1
bkapla1

ASKER

Sorry, it's been a while since I've used a Union join.... where exactly would that go... here's my exact SQL:

SELECT dbo_fk_area_codes.area_code, dbo_fk_area_codes.area_name
FROM tbl_DT_DocTrack,  dbo_fk_area_codes
WHERE tbl_DT_DocTrack.Area_Code=dbo_fk_area_codes.area_code
GROUP BY dbo_fk_area_codes.area_code, dbo_fk_area_codes.area_name
ORDER BY dbo_fk_area_codes.area_name;
Avatar of bkapla1
bkapla1

ASKER

Actually, I figured it out.

Thanks!