Combo Box "reset"

K

ken3260

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?
 
K

ken3260

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

Ofer

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