update query Memo Field Question

[Bigmo2u]

It goes through like it is going to update. A pop-up appears and say are you sure you want to update 1 row. I press yes or Ok and it runs, but it doesn't update.

I try to step into it and strSql = "", but everything else is holding the value it should be holding.

Ok it is posting it to the table, but not the form, Now I need to figure out how to have it populate on the form by refreshing the info or set the focus back on the claimNo.

Thank you so much for your help pbaldy.

 

[pbaldy]

Can you post a sample db? Sounds like it should be updating now.

 

[Bigmo2u]

pbaldy - I wish I could post a sample DB but this DB has a lot of sensitive information in it. It is posting to the table, but now to get it to show on the form, Just need to add some code to refresh the data.

 

[pbaldy]

Oh, I thought you said it wasn't updating. To show the changes on a form, use Requery:

Me.Requery

if it's the form you're on.

 

[Bigmo2u]

pbaldy - thank you so much for your help with this.