Form not updating

[ximistar]

Hi guys,

I am having the following problem. I have a List box on my Form and I am updating HP 12A to quantity 2 and then clicking save and then closing it. When I go back to 12A it shows the quantity as 3 again so it doesn't seem to have updated the record. When I go into the table and update it, it updates fine.

I have attached the picture of my form circluing the buttons I click on to save the form.

Much appreaciated, thanks.

 

[drybone]

What is the macro for the "on click" in your save button properties?

 

[drybone]

I would build a macro for the "on click" event to save record, refresh and then close form. Then try and go back into it to verify it is taking.

 

[JHB]

If the control is bound to the field in the table, there isn't any need for saving it, it is done automatic.
So what is the controlsource for that control?

 

[ximistar]

What is the macro for the "on click" in your save button properties?

Hi,


When I right click on the tab and click on save it still does not save the updated fields

Thanks,

 

[ximistar]

Update, I decided to create a new form with the same details and it works now. Must of been a bug with the other one. Thanks for your help guys!