i need to do a record search in a form but there are a few twists.
1. there is no unique field to any of these records
2. the form has 9 fields, 5 of which are required for creating a record.
3. the solution has to be super easy for the end-users of this database. i'm
thinking of a command button that pops up a form that let's a person select
up to 3 criteria (2 of which are one of the required fields mentioned earlier
and 1 is not -- but i don't want to require any of them for this search so i
need to allow for null values in the ones that they don't pick) and then
searching the table for all records that match those criteria. then letting
the user select which record they want to edit (i would need to know how to
let a user select a record), then closing the popups and displaying the
record in the original form, ready for editing.
i can do the button to pop the 2nd form and the controls for that form
(probably 2 text boxes and 1 combo box, if that matters) but dont' know how
to DO the search, return another popup of results, select 1 and populate the
1st form.
--
Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200511/1