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]

Re: Resetting combo boxes

Got it -
combo4.value = null
in the after update of the other combobox being selected


"Anonymous" <anonymous@some where.far> wrote in message
news:qy56b.3690 02$uu5.70891@sc crnsc04...[color=blue]
> 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.[/color]
When[color=blue]
> 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[/color]
then[color=blue]
> 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 !
>
>[/color]