What Am I Overlooking -- Unable to Display Default Value for Combo Box on Form

[znxm0i]

I have an Unbound combo box on my form which uses the following Row Source code: SELECT [Inventory].[Iventory ID], [Inventory].[Category] FROM Inventory; when the user selects a category from the drop-down list it automatically finds the corresponding record; however, want I'm trying to make happen is when the form is initially opened, I want the first record displayed to contain the default value for the record displayed. When I try and place a default value of "Basketballs" in the Default Value field of the table it does not display on the form.



Any ideas how to fix?

[ranman256]

Basketballs is not the default value.
your 1st field is [Inventory ID], and the combo is probably mapped to col 1 as the field.
SO
you must assign a numeric id as the default value
cboCata = 3 to GET Basketballs.

[znxm0i]

Basketballs is not the default value.
your 1st field is [Inventory ID], and the combo is probably mapped to col 1 as the field.
SO
you must assign a numeric id as the default value
cboCata = 3 to GET Basketballs.

Okay, that makes sense. Thank you so much!