-
If by 'Allen Browne's Search Form' you mean this form: http://allenbrowne.com/ser-62.html it is a good idea, but it is specific to finding details within certain fields on the form. I am searching for all the donations made by a certain individual (form) and the subform is the donor's wishes / details of those donations. The fields of the form or subform are not searched in the criteria. Rather I search names from Contacts table to populate one form with all of John Doe's donations and donation details. I might want all the Doe's so as to select the correct John, by another contact field criteria. I suppose I do place that name in the header, so as to remember which donor the form now references, and I could use Allen's idea there. But that is only really for first name, last name, and city. One of my main reasons for preferring not to use Allen's idea is that it adds several more controls to the form, and I have seen so many forms done by the experts that cause my users to spend hours in being trained how to use the form. My forms are simple, require about 5 minutes of training. One of the methods utilized for that simplicity is to get rid of duplicate or unnecessary controls. The problem with this approach is that it can remove control from the user, and I try not to go that far.
As to filters, it is a good idea and I should have thought of it myself -- [shakes my head now at self]. I haven't used form filters in a while, but this is also my volunteer way of helping an organization do their office work. Filters do answer the issues with "cycle to next". Perhaps I shall pull the items to cycle out of the current search list, and use an option group to display those right on the form.
Thanks for your help.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules