"No" or 0 displayed in drop down

[csoseman]

I am trying to create a field in access that will store multiple fields form a lookup table. When I go to select the options a "0" shows up at the end of the list and "No" shows up in the other field of the same type. Does anyone know why this is and how I can get rid of it? I have looked at the source table for the lookup and there are no extra fields. Any help would be appreciated. Thank you!

 

[CBrighton]

If the combobox bound to anything?

The data in the current record will be displayed in a bound control even if it's not something which is in the rowsource.

 

[csoseman]

If the combobox bound to anything?

The data in the current record will be displayed in a bound control even if it's not something which is in the rowsource.

Yes. Both columns are bound.

 

[CBrighton]

And does the first record have "No" and 0 stored in the fields which they are bound to?

If you open the query / SQL in the rowsource yourself (rather than via the combobox), does the resulting dataset include the extra option?

Can you also please post the SQL from the rowsource of one of these comboboxes.

 

[csoseman]

And does the first record have "No" and 0 stored in the fields which they are bound to?

If you open the query / SQL in the rowsource yourself (rather than via the combobox), does the resulting dataset include the extra option?

Can you also please post the SQL from the rowsource of one of these comboboxes.

When I do a query the No and 0 values do not show up in the bound fields:
Here is the SQL for the 2 combos:

SELECT [lkpJQR].[dep], [lkpJQR].[office], [lkpJQR].[qualName], [lkpJQR].[coDBname] FROM lkpJQR;

SELECT [lkpJobQual].[JobQual], [lkpJobQual].[Description] FROM lkpJobQual ORDER BY [Description];

 

[CBrighton]

But are the "No" and the 0 the current values of the fields bound to those controls in the record which is opened by the form?

 

[csoseman]

But are the "No" and the 0 the current values of the fields bound to those controls in the record which is opened by the form?

I actually just tried to recreate the lookup table structure and add the values back in and that AFTER I restarted my computer. For some reason (not complaining) the "No" and 0 values diasappeared. I really do appreciate the help.