I would like to make it so members filling in a form can select their name or their organization’s name from a list in the database using “+add”. But I only want them to see an alphabetical list of member names and not information in any of the other columns. So I created a “member name only alphabetical” view in the database. Then on the form, I selected ‘limit record selection to a view’ and chose “member name only alphabetical”. But all the hidden fields are still showing up. I only wanted the alphabetical names to show. What am I doing wrong?
Solved
Limit record selection to a view shows hidden fields
Best answer by Databaser
Hi @Lee_Adamson and welcome back!
You always see more info in your form design view then the people who actually have to fill it in do. If you “preview” your form, you should only be able to see the data from your selected view.
+25Hi @Lee_Adamson and welcome back!
You always see more info in your form design view then the people who actually have to fill it in do. If you “preview” your form, you should only be able to see the data from your selected view.
Hi @Lee_Adamson and welcome back!
You always see more info in your form design view then the people who actually have to fill it in do. If you “preview” your form, you should only be able to see the data from your selected view.
Oh - so that’s the secret! Thanks very much for your help. I remembered that I had made it work before but couldn’t remember how I did it. Spent HOURS today struggling with it. Thanks so much!
+25Oh - so that’s the secret! Thanks very much for your help. I remembered that I had made it work before but couldn’t remember how I did it. Spent HOURS today struggling with it. Thanks so much!
Glad I could help! Would yo mind marking my comment as the solution to your question? This helps others who may be searching with a similar question. Thanks!
Glad I could help! Would yo mind marking my comment as the solution to your question? This helps others who may be searching with a similar question. Thanks!
OK. This is the first time I used the Forum so thanks for the tip.
I ticked the solution box. If I didn’t do it correctly let me know.
Thanks!
Lee
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.