Filtering Row Source Data

[bennybee]

I have set up a function that will select a row source in an afterupdate.

but i want to filter this row source.

at the moment the row source is a table that displays all the data in the table, but i want it to only display the data that matches the criteria set in another field.

so that once a date is entered into a field, it will display a field that is associated with that record.

is there a way of doing this?