Filtering a column in a query where I used a custom VBA function

[BnYmN]

When I want to filter a column where I used a self-written VBA function it gives me a type mismatch error. Is there no way to set a filter to that column?

This is an example I found at Google. That's how I use the function but you can't have filter criteria. It gives you an error when you execute the query.

 

[Joe4]

Welcome to the Board!

Firstly, don't name your field the same as your function, that can really cause confusion and unexpected results.

Can you post the VBA code behind your Age function?

How exactly are you trying to Filter it?
Are you placing something on the Criteria row under the "Age" field?
If so, tell us exactly what you are trying.

 

[Micron]

Agree with the name as posted by Joe4. I'll bet [Dob] is a form field reference. You cannot use that syntax - you need the complete forms reference. Assuming you'd rather rename the function as opposed to the field name:

Age:getAge(Forms!frmNameOfYourForm![Dob]) Sometimes the second ! is required, though I'm in the habit of just using a period, but not for the first !.

You can also try a hard coded value that you expect to be passed to the function but I can't tell what's in Dob to make any suggestions.
If you try these with no luck, do post your function as requested.