Resetting combo boxes

[Anonymous]

Quick question - I have a form with with many fields on it. I have three
combo boxes that are used as search engines (Last Name, City, State). For
example, when I open the form, all three search combo boxes are blank. When
I select the Last Name combo box and pick a name (e.g. Bruce), all fields
for that record are loaded on the form. Here's the weird part, if then then
select the City combo box and find a record on that field, the Last name
combo box does not reset back to blank like it is when the form is first
opened. It holds on to the previous search. Is there a way to do a
AfterUpdate Event on a combo box to reset the values (or clear) other
comboboxes on the form?

Thanks !

[Anonymous]

Got it -
combo4.value = null
in the after update of the other combobox being selected
"Anonymous" <an*******@somewhere.far> wrote in message
news:qy56b.369002$uu5.70891@sccrnsc04...

Quick question - I have a form with with many fields on it. I have three
combo boxes that are used as search engines (Last Name, City, State). For
example, when I open the form, all three search combo boxes are blank. When I select the Last Name combo box and pick a name (e.g. Bruce), all fields
for that record are loaded on the form. Here's the weird part, if then then select the City combo box and find a record on that field, the Last name
combo box does not reset back to blank like it is when the form is first
opened. It holds on to the previous search. Is there a way to do a
AfterUpdate Event on a combo box to reset the values (or clear) other
comboboxes on the form?

Thanks !