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!