Using lookup value to filter a split form

thanks in advance for any help

I'm using a macro to perf开发者_开发知识库orm a filter on a split form by taking a value from a text box.

Everything works fine, except for fields that use a lookup to get there value. Unfortunately I cant figure out how to search the shown value in the field as opposed to the bound column.

Should I use dLookUp? I cant seem to get it to work

Any help appreciated

Cheers

Noel

This was glaringly obvious.

Just needed to add the apropriate field from the related tables to the form.

If I could delete this quetion I would!