I have a form called block that contains: vineyard & block fields.

I also have another form called analysis which contains vineyard and block look up fields.  I am trying to filter the block lookup field data based on the vineyard selected in this form.

I initially got a type mismatch error when I tried to do this:

I then tried using .toString() function which eliminated the error but does not show any data in the block field when I run the app.

If I use an actual name in the filter-i.e. "Rotta Vineyard", the Rotta Vineyard blocks populate the block field.

I have also tried using the Vineyard ID field instead without success.

I would be grateful for your assistance.

Thanks,

Jeff