There is probably a very simple explanation for this, but I can't figure it out...I have a form that users will be searching using Filter by Form. Currently, when the form is in Filter by Form mode, the usual drop down boxes next to each text box only show "is null" and "is not null" and do not show a drop down list of all the entries in the field. But if I go to the table properties and change the index property to "Yes (Duplicates OK)", then when I use Filter by Form in my form and click on the arrow next to the text box, there is a list of the entries that have already been made into that field.
My question is this: If I want users to be able to search through previous entries when they Filter by Form, should I change *every* field in the table's index property to "Yes (Duplicates OK)"? Or does this have potentially bad consequences for my table?
Thanks for any advice anyone might have to offer!
My question is this: If I want users to be able to search through previous entries when they Filter by Form, should I change *every* field in the table's index property to "Yes (Duplicates OK)"? Or does this have potentially bad consequences for my table?
Thanks for any advice anyone might have to offer!
