HELP - Refresh Text Box data form updated Table

Help!
I'm sorry I've not used access for a while and just can't figure out how to do the following....

I have a table - TblExcelChecks - it contains a field - exportcomplete. This table is populated from an excel file.

I have a form - Switchboard - on which I have a bound text box - that is populated from the exportcomplete field of the TblExcelChecks table.

The problem I have is this:
I run a macro that runs a delete query and clears all data in the TblexcelChecks table and then re-imports with new data from an excel spreadsheet.

As soon as I run this macro, my text box on the form shows #deleted. However, the table now contains updated data.

How can I get the text box to update with the new data without having to close and re-open the form????

All help appreciated.

Thanks

I think you could add the line

Me.Refresh to your macro

Hi - I tried that but I'm obviously doing something wrong as it wont refresh. I have to close the form and re-open it for the data to refresh. Any other suggestions?

I'm not sure... you could try
Application.RefreshDatabaseWindow

Kazbarina,
Did this resolve the issue?

Hi. No unfortunately it didn't. However, I have managed to solve it. I set focus to the text box in question and then did me.requery.

Thanks