After data entry: generate and display list of entries with a specific matching value

[Thirith]

I'm currently working on a database of funding proposals, and I'm looking for a good way to do the following:

• When a new proposal is entered on the main form, Access should check whether the same person has submitted any earlier proposals. (I'd imagine this when the field for the applicant's name is filled in.)
• If there aren't any other applications by the same person, nothing happens.
• If there are any other applications by the same person, a list pops up (not sure what format makes most sense: text box? form in datasheet view?) listing those proposals, and a number of other values on the same table.

How would the Access pros go about achieving this?

 

[UncleCatwoman]

I would have a list box on the side of the form and, when the name of the proposer is entered/selected, in the AfterUpdate event for the control, I would requery the list box for proposals made by that same person. If there haven't been any, nothing will appear. If there have, they will. Decide what info you want to display and how to sort it.

 

[Thirith]

Thanks, that sounds like a good way of handling this.