I have values in a table like this:
S01-2000
S01-2001
R01-2000
etc....
As you can see I have two values with 2000, just prefix is different. I capture the prefix in a separate field in my form (eg: 'S01-")
When I try to implement the AutoComplete event I would like to filter the results, but it seems I cannot pass the "S01-" field to the database read. it only takes values from the dropdown field you are typing in, that's it.
Hope this makes sense
S01-2000
S01-2001
R01-2000
etc....
As you can see I have two values with 2000, just prefix is different. I capture the prefix in a separate field in my form (eg: 'S01-")
When I try to implement the AutoComplete event I would like to filter the results, but it seems I cannot pass the "S01-" field to the database read. it only takes values from the dropdown field you are typing in, that's it.
Hope this makes sense
This topic is locked and no more replies can be posted.
