Using Combo Box To Filter Records

[jereece]

I have a form (frm_data) that shows my data (tbl_data) via a query (qry_data). One of the form fields is a combo box "Status". The options for the combo box are "Open" and "Closed". The query I the form is based on has a criteria to only show the Open items. When I change the status on my form from Open to Closed, I have to close the form and then reopen it in order for that record to no longer show.

Is there a way to update the form after I make a change to the "Status" field?

As always, I appreciate the support.

Jim

 

[rainman89]

try requery if its a form with a subform put me.subformcontainername.requery in the afterupdate event of the combo box

 

[jereece]

It's not a subform. Just a regular form.

 

[Rabbie]

Try

me.requery

in the afterupdate event of the combo box

 

[jereece]

Thanks......

Jim