How would one go about doing this?

My problem is -- I have a form, and when I edit the data, then click the save button, the table is update...However, I have to close the form and reopen it for the changes to appear.

I have tried RecordSet.ReQuery, but it gives me an error on some of my other code, stating that the value isn't valid.

I was thinking of just editing the recordsource and updating, but I don't know how to make this code work in a SQL statement in VB code :/

VB Code:
  1. SELECT DCount("ID","WorkerInformation","ID<'" & [ID] & "'")+1 AS SeqNr, * FROM WorkerInformation;

As the double quotes raise an error...SO I tried it with single quotes, but that didn't work either...

I'm gonna keep plugging away at this, but if anyone can help me Id really appreciate it


And I have a sinking suspicion I am going to owe Danny another rep