>>I would like to have a have a combobox set in dropdown list format display only rows belonging to the child records of the parent table. I am trying to select an active account and then display all patients belonging to this account with a combobox.
>>
>>I can do this with a filter - but it is slow. Any ideas would be appreciated.
>>Thanks in advance.
>
>Select appropriate child records into cursor and use it as Combo.Rowsource

Or use a parameterized view as Combo.RowSource
* account changed
=Requery("PatientsView")
thisform.Combo.Requery()
thisform.Combo.Refresh()