I'm trying to make a selection form for selecting a single customer from a database that contains quite a lot of customers. The end user will type either the birthdate of the customer, their first name or their surname; or a combination of these, any that can contain wildcards or be only partially specified. The birthdate, firstname and surname are stored in separate columns in the database.
If I make 3 comboboxes, one for each of the 3 criteria, how can I make the 3 comboboxes dependent on the content of all 3? I mean, if I type a partial birthdate, how can I make it so that the firstname and surname box only show those customers whose birthdate starts with the date I've typed in the birthday combobox? Thanks /Janoch
