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]

[jojowhite]

On the Load Event of the Form, use DoCmd to GoTo New Record.
When a selection is made on the combobox, you Search it on the form:

Private Sub Form_Load()
'goto new record so textbox is empty
DoCmd.GoToRecord , , acNewRec
End Sub

Private Sub Form_AfterUpdate()
'refresh combobox
YourCombobox.Requery
End Sub

Private Sub YourCombobox_AfterUpdate()
    If YourCombobox.ListIndex <> -1 Then
        DoCmd.SearchForRecord , , acFirst, "PartName='" & YourCombobox & "'"
    End If
End Sub

[XeviBatlle]

Perhaps an easy solution is to set the text box unbound until the combobox is filled. I mean to set the textBox controlsource to Null in dessign mode and assign it in the AfterUpdate() combobox event.