combo box recordsource question

[imstuck]

Is there a way to change a combo box's recordsource if an item is not found in the list? I want the user to be able to search another field (but in the same table) if a name is not found in the list under lastname. The other field is an "other name" field. I tried setting the recordsource for the combo box by having the user press a command button, but it gave me an error message saying "object doesn't support this property or method".

How can I accomplish this?? Thanks--

 

[braindead2]

this seems to work for me
dim strsql as string
strsql = "select [other name] from mytable"
me.combo0.rowsource = strsql
me.refresh