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!!!

Mju,

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

--
Steve Schapel, Microsoft Access MVP


"mju" <(E-Mail Removed)> wrote in message
news:3031E340-CA36-4D81-91E9-(E-Mail Removed)...
> 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