Check box with subform

[zxmax]

Greeting all,
i have a 2 main forms "Residents" and "order"
The "Residents" form has a subform coming from the order main form

in the "Order" form, i have a Check box feild , what i want to do is , when this check box is checked, i want that entry to be shown in the subform,

is there anyways that could be done,? i hope i'm clear in my question

Thanks in advance,

 

[LittleSmudge]

So what you want is When check box is not ticked then the record does NOT appear ?

Then make the RecordSource of your sub form itself something like

"SELECT * FROM tblTableName WHERE tickFieldName"

replace tblTableName with the name of the table that the "Order" for is bound to

replace tickFieldName with the name of the field in tblTableName that the tick box is bound to.

Then in the tickFieldName.AfterUpdate event put the code
Me.Requery
so that when the user unticks the tick box the record will immediately vanish.



'ope-that-'elps.






G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.