searchmacro doen't work when initiated from listbox
Hi there,
I've been working on a database for a Dutch nursing home, but I'm struggling to get it to work. The file provides for a userform that enables users to search for residents and retrieve their appartmentnumber and the adress of their legal representative. This userform consists of three parts; in the first, the user can type the full or partial name of the resident of interest in a textbox; in the second phase, all matching registrations are presented in a listbox; and in the third phase, a macro searches for the name selected in the listbox and retrieves the corresponding appartmentnumber and adress. The first two phases of the userform work fine, but in the third phase, the macro fails to find any matches even though it is practically the same as the macro used in phase 1. I'd greatly appreciate it if anyone would take a look at the attached file and help me out here. Thanks in advance.
Last edited by WCJanssen; 07-05-2009 at 03:28 AM.
|