newbie combobox text property question

  • Thread starter Thread starter tmaster
  • Start date Start date
T

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
 
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.
 
Back
Top