All,
I don't know if anyone noticed, but this thread made a quick jump from June 12, 2001 to Feb 25, 2002......roughly 8 1/2 months between posts. The Steve who offered to send someone a copy of his db may not even be around anymore......
That said, this seems to be a popular thing.
I went though this a while back and have developed the following system that has worked well for me.
I use 3 forms. One to gather search criteria, another to display results in a summarized form, and one more that displays all the detailed information of a record selected from the list in the 2nd form.
First is a search form that has a number of textboxes, combo boxes, and checkboxes. This form allows a user to enter criteria into any combination of fields and select whether the search some fields is exact or partial (i.e. "=" or "Like"
. When the user has entered their criteria, they click a command button which builds the where clause of a SQL statement and then opens the 2nd form based on the resulting recordset.
The second form is a continuous form that displays the fields from the query generated by the first form. The double-click even of the controls on this form opens the third form displaying the details of the record that was double-clicked.
The third form is the form where records are actually entered/edited.
This may be enough for some of you to get started. I'll try to figure out how to post some kind of help document. I'll include more details on the forms and the code that makes them work. It will probably take me a couple of days to get this together and post it. _________
Rott Paws
