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.

[Ken Sheridan]

I would suggest that you base the form on a query which references the unbound combo box, in the form header section, as a parameter on the PartName column: Nz(Forms!NameOfForm!NameOfComboBox,"") The form need only return the PartName column in a bound text box. When the form opens, the combo box will be Null, so the form will return no rows. In the combo box's AfterUpdate event procedure requery the form with Me.Requery to return the rows which match the value selected in the combo box. You can then correct the value. In the text box's AfterUpdate event procedure requery the form. The corrected row will be dropped from the form's recordset. The text box will continue to return any more incorrect values which match that selected in the combo box. Once all such values have been corrected the form will return no rows, and another value can be selected in the combo box.

[Welshgasman]

If you referred to a column in the combo by the control, surely that would be empty as well?