I've seen your Buttons on Reports videos earlier this month, but have a little twist on it. First, allow me to explain my database.
I've built a system I've used for over 3 years that "gathers data for and gives donors date-specific reports to assist them in filing annual taxes." After clicking on the 'Search Donations' button in the 'Central Control' form, the 'Search Donations' form opens allowing report generation based on specific criteria. I have 2 lists of donors: Current and Former.
I would like to replace the 'Choose a Donor' label on the search form with a button that swaps current donors and former donors (my 2 list boxes). I've put the 2 on top of each other (current over former it's a space-saver!). I'd also like to list the start and end dates for selected donors in that form or, better yet, display them automatically in text boxes so I can just hit Search.
Thank you for any assistance you will/can provide.
Sam Comer Bridge City, Texas
Scott Axton
@Reply 3 years ago
First, and foremost, I hope you don't literally have 2 lists. The best way would be to have a single list with a field that is true / false such as Richard shows with his IsActive in many of his videos. You can name it what ever you want IsCurrent or whatever but keep the data together.
Why? What if a donor goes from Current to Former? With 2 lists you have to copy over all the data from one to the other, etc, etc.
Then if they become active again what happens? Copy all that data back or enter them in new - duplicating info?
The better way is to use one table and mark them using the IsCurrent.
Second, for your search form it will become much easier. If you run a search thinking someone is current but in fact they are former you have to run the search again. Time waster.
I would put in a Value List Combo specifying 3 choices: All, Current, Former. Then use the value in there to filter your search. You could use a Triple State check box as well but I find that most users are confused by those. I tend to keep check boxes for just yes/no or true/false only.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.
