Johannes ,
I think you need to use a event who fire some macro's to change the SQL
statement behind the comboboxes depending on the content of the others
hope it helps
Fernand
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
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
