Subform filtering

[mcgooie]

i have a form with a subform on it. the subform has 2 columns - one of which is hidden. Assume the other column is called "type".

i was wondering if there is an easy way to 'hide' records in the subform which have "type" = "Car"

thanks

 

[edtab]

One way to do it:

In the "On Load" property of your subform, filter out any record
with type = "Car".

Code:

Me.recordsource = "SELECT * from tableName WHERE Type <> 'Car' "

 

[mcgooie]

where is the "On Load" function?? i can only see "On Enter" and "On Exit" under the Event tab?


thanks for code btw

 

[mcgooie]

nvm found it