J
John
I've used the 'find as u type' utility
(http://allenbrowne.com/AppFindAsUType.html) many times successfully, but
I'm now running into something I can't solve. When I base the form on a
table or selection query, everything works fine. But when I base the form on
a query which in itself is based on a query and a linked table I get the
following behavior:
1. The form_load works fine.
2. Filtering works fine as long as the value is found.
3. When the typed value can't be found the record fields disappear and the
focus is set to the field where you enter the value (the typed text is
selected).
4. When I delete the 'type ahead value', the record fields still don't come
back.
5. Only way then to make it work again is to choose the field again that I
want to filter. Then all record fields and values come bank to the screen.
I suspect it has to do with the fact that the underlying query is based on
another query and a linked table.
Any ideas to fix this?
Thanks in advance,
John
(http://allenbrowne.com/AppFindAsUType.html) many times successfully, but
I'm now running into something I can't solve. When I base the form on a
table or selection query, everything works fine. But when I base the form on
a query which in itself is based on a query and a linked table I get the
following behavior:
1. The form_load works fine.
2. Filtering works fine as long as the value is found.
3. When the typed value can't be found the record fields disappear and the
focus is set to the field where you enter the value (the typed text is
selected).
4. When I delete the 'type ahead value', the record fields still don't come
back.
5. Only way then to make it work again is to choose the field again that I
want to filter. Then all record fields and values come bank to the screen.
I suspect it has to do with the fact that the underlying query is based on
another query and a linked table.
Any ideas to fix this?
Thanks in advance,
John