Clearing text boxes

[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 Schapel]

Mju,

Can you please let us know what you have in your macro so far?

--
Steve Schapel, Microsoft Access MVP

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.

__________ Information from ESET NOD32 Antivirus, version of virus signature database 4364 (20090824) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com