Best way to update fields

[crowegreg]

On a form, I have a drop down list containing an ID number. After the user selects an ID number, the record is retrieved and the fields on the page are updated with this record. My problem is not all the fields have data. So, then the user needs to update these fields. How is the best way to provide the user with a drop down list for the fields that do not have any data? I should note that when the record is retrieved, if a field has data, I've set enabled to false. Thank in advance!!

[June7]

Is the ID number 'drop down list' an UNBOUND combobox used to input filter criteria?

Options for the other data entry fields comboboxes:

1. pull values from a lookup table
2. pull values from the data table: SELECT DISTINCT fieldname FROM tablename ORDER BY fieldname;
3. a static ValueList typed into the RowSource property.

[crowegreg]

Ok. I'll try that.