If I want the recordset to populate fields in a separate form from the one I originally had the query in (which I am assuming is logical and common), would I have to declare the recordset as a public declaration?
Also, does anyone know the magic code to allow the recordset appear in another window as you type...so that the user could see if he/she is getting close to the desired name? For example, I type circus into the text box for the last name search field...I want to see the first record that starts with a c pop up when I type "c", the first record that starts with "ci" pop up when I type "ci," etc....
