How to display records in a form for a specific criteria

[Rizvi]

Hi, if anybody can help me out i am new to access. i have created a form in which there is also a sub form displaying all the records of the table. when selecting record in the list displayed in sub form the form is updated with that record. the problem i am facing that i am not able to filter the records of sub form on a criteria. i have a field in the table "Authorized" which is Yes/No attribute and i need only those records where the value of "Authorized" field is to be displayed when the form is loaded.
if any body can help me out
thanks

[ranman256]

instead of a subform, you should just use a form.
Subforms are for showing filtered of the item in the master form.

You said yours shows all records.
"Authorized" is 3 settings: Yes/No AND both.

If you DONT use a sub form, then you only need put the tick boxes on the header, then:

sub chkAuthorized_Afterupdate()
  Me.Filter = "[Authorized]=" & chkAuthorized.value 
  Me.FilterOn = True
end sub

then click the TOOGLE FILTER button on the main menu bar to show all records.

[JoeM]

Deleted...

[Rizvi]

thanks for the reply. attaching screen shot of my form. if you can see the form is split in datasheet and form. i already have the following code which runs when the record is selected in the list.
Private Sub Form_Current()
Me.Parent.Filter = "Txn_number=" & Txn_number
Me.Parent.FilterOn = True
End Sub
if you can help me out in this. i only need when this form is loaded it should only display the records where "Authorized" field is not "ticked" or value "No"Doc1.pdf

[ranman256]

is parent the subform name? (if it is, why would it be called 'parent'?)
your tick box is IN the parent form so it would be:

me.filter = "Txn_number=" & Txn_number
me.FilterOn = true

if you want to filter the subform (use the BUILDER to get the path correct)
but it may be:

me.subform.form.filter = "Txn_number=" & Txn_number
​me.subform.form.FilterOn = true