Clearing text box

M

mju

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.
 
A

Arvin Meyer [MVP]

In the after update or the after insert event of the form, set the textbox
values to an empty string:

Me.txtWhatever = ""
Me.txtAnotherOne = ""
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

clearing text box 2
Clearing text boxes 1
Form Problems with Combo Boxes 3
link form fields ?? 1
Update query based on a form value 9
List Box search 4
Reading a value from a text box 5
combo box filter 1

Top