text box linked to field table not requerying/refreshing

[snipe]

Hey guys,



I have a 2 text boxes on a form that are directly linked 2 date fields in an underlying table. After a button is pressed, a subroutine fires. This sub changes the data in the underlying table. The last 2 lines in that subroutine are a requery of the 2 text boxes that I am having issues with. When the whole thing is done, the 2 text boxes say "#Deleted." I have even created a button just to requery those 2 text boxes. That doesn't work either. Changing to design view, then back to form view doesn't refresh the text boxes either. I have confirmed that the data is in the table. Close the form and reopening does refresh them.

Ideas on why the requery isn't working?

[orange]

I've just mocked this up. Form based on a table, 2 date fields in text boxes.
A button on the form that does a save record in on click event.

I change the record manually on the form, then click the button.
Record is saved with updated values. No errors.
No requery needed.

Perhaps your subroutine is doing more and it is something there that's causing the issue???

Click event (via wizard -)

Private Sub Command9_Click()
On Error GoTo Err_Command9_Click


    DoCmd.RunCommand acCmdSaveRecord

Exit_Command9_Click:
    Exit Sub

Err_Command9_Click:
    MsgBox Err.Description
    Resume Exit_Command9_Click
    
End Sub

[snipe]

Ah you are a bit backwards in what is going on with mine.

The 2 text boxes pull the "Date From" and "Date To" of the table. The show the user what range of data is currently stored. Every record in the table has the date from and date to.


The user inputs 2 dates into 2 date pickers (different than the 2 text boxes that are giving me issues). They click the button that fires the sub. The sub clears the table, runs a bunch of queries and calculations, then appends the new data into the table, then (theoretically) requeries the 2 text boxes so the user can see which date range is currently stored.


I have deleted and recreated those text boxes thinking they may have been corrupt. I have tried 2 different methods of requerying: DoCmd.Requery "textbox" and me.textbox.requery. Nothing seems to work.

Everything else works great. Any queries and reports that go off the stored data have no issues. This is just baffling me....

[Bob Fitz]

Have you tried a requery of the actual form instead of the text boxes.

[snipe]

Bob Fitz for the win!

Thanks for the help you two!

[orange]

Bob and I were glad to help. (Good one Bob!)