clearing text box

[mju]

Clearing text boxes….

How do I clear text boxes when a selection is made from a combo box
returning null information?

E.g
1) A user select company name from CompanyNamecbo.-->I have this working
2) CompanyNamecbo returns contact names in Contact_names_Cbo I have this
working
3) User selects name from Contact_names_Cbo and contact information will
appear in different text boxes. - I have this working
4) table is updated with any new changes I have this working

The problem that I am having is that the values in the text boxes does not
clear up if there are no contact names when a company is selected.


Thanks alot!!!

 

[Steve Sanford]

More info please......

Are the combo boxes and/or the text boxes bound or unbound?

What code do you have in the after update event of the combo boxes?

(How are you doing steps 3 & 4? code?)



HTH

 

[Paolo]

Hi mju,

I assume that you have code in the afterupdate event of CompanyNamecbo that
populate Contact_names_Cbo. To this code add
text1=""
text2=""
etc. where text1, text2 etc. are the text boxes you wanna clear up.
So every time you choose something from CompanyNamecbo your text box are
cleared. When you choose something from Contact_names_Cbo, if there are
contact names to choose, informations'll appear in the text boxes. Otherwise
the text boxes remain blank.

HTH Paolo