I haven't found a way to do this and was wondering if it can be done. I'd like to create a Find button on a layout, that on clicking would generate either a pup-up or dropdown menu with a value list that could be selected that would then find the records with that value in a specified field.
As an example, I have a membership database for an organization where renewals are recorded in batches by months. Each month is recorded in a Value List. The Current batch field is filled in by selecting clicking in the field and then selecting the month from the value list that pops up. I currently solve the problem by creating separate Find scripts for each month and programming individual month buttons (Jan08, Feb08, Mar08, etc.) but the number of buttons grows gros and grows. I'm trying to figure out if I can create a script for a "Find batch" button that would result in the months value list popping up, then returning the records that have that month in the "Current batch" field. If it can't be done, that would be useful information as well. FMPro 8.5 if that makes a difference. Thanks. Kevin
