By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,837 Members | 1,195 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,837 IT Pros & Developers. It's quick & easy.

Resetting combo boxes

P: n/a
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 !
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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 !

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.