Resetting the Combo Box

[gaby58]

Hi All,

I have a Combo box on a form and the form has about 10 text boxes and all the values are coming from Query, when I select the value in a combo box, it will display according that value, however when I don't select anything also then also the values in the text boxes still exist, how do I reset to empty values in the text box.

Also if the value is entered in one of the text box which has unique value, it should be able to display values on the other text boxes, is it possible?


Thank You

[June7]

If controls are bound to data then changing a value in textbox changes the data in record. Controls used as input for filter criteria must be UNBOUND. Review http://allenbrowne.com/ser-62.html

If you want to provide db for analysis, follow instructions at bottom of my post. Identify the form that has issue.

[gaby58]

Thank you, actually when the form runs the combo box has no value, but all the text boxes have value, so they also should not have any value and when we toggle back to value it should display all the values(it is doing already), again when we go back to no value in Combo box, it should reset all the text values to null. How to accomplish this one?

[June7]

Don't bind textboxes to fields. Or if bound to fields, move to New Record row.

I don't really understand what you are trying to accomplish.

Did you review the link?

[roaftech]

If I understand your requirement correctly ...
When you open a form with a combo box as a selector for a data record, the selector itself is blank but the other fields have (apparently spurious) data in them. You would prefer those fields to be blank whenever the selector is blank. ??
If that understanding is correct, then one solution is to set those other fields' visibility to 'No' whilst the selector is blank. I can't recall the actual syntax but it would be something like:
If me.selectorbox = "" then me.otherfield.visible = no
but you will need to research the actual coding to make it work.

[June7]

Exactly how are you causing the textboxes to be populated with data related to the combobox?

[davegri]

If you have form textboxes bound to a table, your thinking is all wrong. The form presents a record in the table. If you blank out the form, you will blank out the current displayed record. Not delete it, but blank out its fields in the table.
That probably is not what you want.
Why do you want to see a blank form?