I have a form that has a combo box and a command button. The combo box references a table called 'doctors' for example. The table has a field called drname which is displayed in a dropdown combo box.
The command button under command1.click runs a query to search the drname field for the highlighted name in the combo box. How do I tell the query under command.click which name is currently highlighted in the combo box?
I've tried referincing the combo box in the query by--
Under command.click I placed:

'vdrnam = thisform.combo1.value'

then my query filter says:

'where drname = m.vdrnam'

Any suggestions on what else I could try?