newbie combobox text property question

[tmaster]

I populate a combobox with UNIQUE values from a field in my table. I got
example this from another post: Set Row Source Type = Table/Query, and Set
Row Source to:
SELECT DISTINCT tblEquip.Category
FROM tblEquip
ORDER BY tblEquip.Category;

This works fine, but how can I set the combobox's .text property to equal
the value of the Category field for the current record?

Thanks

 

[Bill Crawford]

HI:

In the combobox bound column property, set it equal to the column that
contains the field that will store the record in your table.