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