Combo Box "reset"

G

Guest

Combo box on form gives list of Customer names. Whe main form is opened, the
box is blank. Once name is selected, it finds that customers info and fills
several subforms. One of the sf's also lists customer name. When I use the
scroll buttons on main form to change customer however, the combo box name
does not change, so its confusing with 2 different names showing. How can I
get the combo box to revert back to blank after updating subforms?
 
G

Guest

PERFECT! Thanks.

Ofer said:
On the After update event of the SubForm you can write

Me.Parent.[Combo Name] = Null


ken3260 said:
Combo box on form gives list of Customer names. Whe main form is opened, the
box is blank. Once name is selected, it finds that customers info and fills
several subforms. One of the sf's also lists customer name. When I use the
scroll buttons on main form to change customer however, the combo box name
does not change, so its confusing with 2 different names showing. How can I
get the combo box to revert back to blank after updating subforms?
Click to expand...
Click to expand...
 
G

Guest

Glad I could help, good luck

ken3260 said:
PERFECT! Thanks.

Ofer said:
On the After update event of the SubForm you can write

Me.Parent.[Combo Name] = Null


ken3260 said:
Combo box on form gives list of Customer names. Whe main form is opened, the
box is blank. Once name is selected, it finds that customers info and fills
several subforms. One of the sf's also lists customer name. When I use the
scroll buttons on main form to change customer however, the combo box name
does not change, so its confusing with 2 different names showing. How can I
get the combo box to revert back to blank after updating subforms?
Click to expand...
Click to expand...
Click to expand...
 

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

Combo box list based on information entered in another combo box 2
Main Form with a Subform with Check and Command Boxes 1
Find name in subform using cbox and go to that record # in main fo 2
synchronized Combo Boxes in subforms 2
Making all controls match selection of combo box 0
Customer Combo Box 2
subform requery 2
Subform fields auto-filled based on Main form combo box value 8

Top