My objective is to have an easy way for a user to get to the record that they need to edit/delete (on a form) quickly, without having to sroll through every record to get there. I want the user to have a way of selecting (or typing in) data in a combo box from the available records in a recordset. It would be nice if there were a way to have a multiparameter query underlying the form so that all the user has to do is select from whatever field he/she would like to search on to find the record. I know you can do this by basing the form on a query -- I just hate the default pop-up box -- rather than a series of pop-up text boxes asking the user to type in data for each parameter, I would like a way to display one pop-up box with all of the parameter fields displayed as combo boxes with all of the possible choices in a given recordset displayed in each pull-down list.
Any ideas?
Thanks.
-CoddFish
Any ideas?
Thanks.
-CoddFish
