How to filter an Add/Edit table form

[Lemmy Winks]

hi,
How do you filter an add/edit table form on a field. I only want records to show up that have a value of "XRAY" in a certain field.

 

[JamesMcS]

You could do it in VBA on any number of events, depending when you want the filtering to occur:

me.filter = "[Certain Field]='XRAY'"
me.filteron - true

in a form event would do the trick.