combobox with recordset

[Bird Byte]

I am setting up a form in access for data entry. It has a combobox that
populates from a lookup table. When the form loads, a recordset is filled
with the last record from a table. The table includes a field that is
eventually updated from the value in the combobox. I'd like to check the
recordset for the value it has for the combobox, and populate the combobox
with the next item in the lookup table.

With number fields I discovered I could do txtName.text = rs.Fields(2).Value
+1. Is there anything similar for comboboxes filled via a lookup table, or
should I try something entirely different?

cboAreaID.text = rs.Fields(3).something(?)

Thanks!