>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?
You could directly use :
where drname = thisform.combo1.value
Cetin