Filter records in a form

[aymanmb]

I have a form that contain a subform. the main form displays Orders Table (client nam, purchse number, etc.. and a check box to indicate if the order is colpeted or not.

the subform contain the order details (items, Qty, etc...).

I want to add a button or a control that will allow me to see only un completed orders (unchecked) in the same form (that is why I did not make a query to filter records and show results in a second form).

is there a way to do it

thanks

 

[MStef]

Hello aymanmb!

Look at "DemoUnchSubformA2000.mdb",
I think it is what you need.
Ope "frmOrder" and try.

 

[aymanmb]

thanks you. I am not sure this is what I need. have a look at the attached databse. open orders form, you will see a check box names completed. I need the filter to show only uncompleted (unchecked) orders in same orders form (without leaving it).

can it be done, if yes, please explain how and any codes needed

thanks

 

[aymanmb]

sorry, attachment is here

 

[MStef]

OK Ayman Moussa!

Here it is. I put the first record is completed.
Next time take off a password.

 

[aymanmb]

great, thanks a lot

 

[aymanmb]

sorry but what diod you mean by next time take off a passowrd

 

[MStef]

I mean, you sent me a mdb protected with a password.

 

[aymanmb]

really, I did not do that, I am not sure how it ended up with a password, sorry anyway

 

[MStef]

Ok, newer mind.

 

[aymanmb]

Hi again,

sorry I did send you an older version of the database. I tried to do same on my latest version but failed (give syntax error). I tried to find out what but could not. I would appreciate if you can redo the 2 buttons with their code for me to study the difference.

thanks a lot

 

[aymanmb]

Dear MStef,

would appreciate your help

thanks