DLookup Question - typing vs selecting from drop down

[ltkling]

I have a Dlookup formula that works fine when the user clicks on the drop down menu to select the right physician ID. However, if the user starts typing the 5-digit ID, and access locates it in the drop down menu, the name field that is supposed to populate once the ID is selected remains blank. Users are typing to start looking up from the menu because the table is huge.
Thanks,
Lisa

 

[dhookom]

Typically your combo box can display multiple columns. Also rather than using DLookup(), consider taking what value is looked up and putting it into a column in the combo box. Then replace the =DLookup() with something like:
=cboMyCombo.Column(x)
x is the column number with the first column is 0.

Duane
Hook'D on Access
MS Access MVP

 

[ltkling]

Thanks so much for your help dhookom - That worked!
Lisa