How to apply filter to a list box

[DeoM]

Hi,
I have a form for a Work Order Table. It has a list box showing work order records, choose one and the form goes to that record.
When i filter the form to let say State-"California"; i want the list box to also filter out and only show those with California as State. Right now, the form filter is fine but the listbox still shows all records.
Please give me the code/syntax on how to filter the listbox too.
Thanks,
Jun M

 

[PHV]

You have to rebuild on the fly the RowSource property of the listbox with the correct WHERE clause.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[DeoM]

Thanks PH, I figured it out.