Battling Comboboxes!

[Jaybird]

Normally, I have one search combo per form, but it has been requested that
the user be able to search for records by a variety of means. Dutifully, I
set up several unbound comboboxes set up to search for records based on the
search criteria. These seem to conflict. If you search using one, you may
not then search using another. I noticed that the selected values do not
disappear when entering another combobox. I wonder how I can get around this?

 

[SteveM]

One option that my users like is a custom shortcut menu where they can
right-click on a field and then click the 'Binoculars' find button. I often
include Copy and Paste in this shortcut menu too.

You could use the OnClick event of the combos to clear the others.

What code are you using to find a record?
Are you setting a filter or a bookmark?

Steve

 

[Jaybird]

It's a bookmark. I simply used the wizard three times to create the combos.
(It's about the only experience I have with recordsets...) Anyway, I like
your idea. What code would you use to clear the combos?