Reload form based on combo box

[RPGguy]

I have a form that displays orders. I added a combo box so the user can select an order status and show only those types of orders(Open, closed, etc..). My data selection uses this field as the filter. I want the user to select a different order type and have the form refresh showing only orders with the new order type. When I change values in the combo box the form shows the old data. How do I refresh the form?

Thanks. This is a fantastic site. Especially for a 20 year RPG programmer teaching himself Access.

 

[THoey]

I think you want to add the following command in the On_Update event of the combobox:

FormName.requery Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.

 

[RPGguy]

I tried that but I'm not using a query. I'm using the record source and filter properties. I got a msg 'variable not defined' when I added frmOpenWO.Requery.

Thanks