Open form with text box blank

[Carmine]

THE SITUATION: I have a form that contains a combo box and a text box. The purpose of the form is to correct data misspellings or inaccuracies in a table, call it the “NameTable”. This is limited to only one NameTable field, “PartName”. When the combo box is activated and a PartName selection is made, that PartName appears in the text box. The user can then make corrections and save then them. This situation works perfectly.



THE PROBLEM: When the form opens, the combo box is blank, but the text box contains the first PartName in the NameTable.

WHAT I WANT: When the form opens, the combo box is blank, but I want the text box also to be blank, that is until a combo box selection is made, then the user can make corrections and save them.

Thanks in advance,

Carmine

[mike60smart]

Hi Carmine

Can you upload a copy of the Database with no confidential data?

[davegri]

You will need to make the textbox unbound.
The after update event of the combox can populate the textbox.
The after update event of the textbox will need to trigger an update query to update the correct record in NameTable with the contents of the textbox.

[madpiet]

THE SITUATION: I have a form that contains a combo box and a text box. The purpose of the form is to correct data misspellings or inaccuracies in a table, call it the “NameTable”. This is limited to only one NameTable field, “PartName”. When the combo box is activated and a PartName selection is made, that PartName appears in the text box. The user can then make corrections and save then them. This situation works perfectly.

THE PROBLEM: When the form opens, the combo box is blank, but the text box contains the first PartName in the NameTable.

WHAT I WANT: When the form opens, the combo box is blank, but I want the text box also to be blank, that is until a combo box selection is made, then the user can make corrections and save them.

Thanks in advance,

Carmine

Neither here nor there answer, but if you can find all the misspellings and add them to a table, you can add a column to it and add another column and add the correct spelling. Then you just do it once.

UPDATE MyTable mt
SET mt.[ValuesSpelledWrong] = ct.[ValuesSpelledRight]
WHERE mt.[ValuesSpelledWrong] = ct.[ValuesSpelledWrong]