Disabling Ribbon prevents doCmd.SAve

[Tompen]

Hi,

I have a very strange issue. Im running a form where I update the status in a checklist (continuous form) when I check a box in this form the overall % status is updated on the parent form which is the list of projects (each having a checklist).

Here comes the problem. Everything is working great but as I am about to package this for the end user I want to diable the ribbon. When I do this the doCmd.Save operation I have after clicking a chackbox (allowing the overall status on the parent form to respond) doesn't work anymore. The effect on the overall status on the parent form is therefore delayed until I change record. For some reason it seems the "ShowToolbar "Ribbon", acToolbarNo" I have ion the Load event of the main form prevents the doCmd.Save operation in the subform.

Any idea of how to address this?

 

[Ari]

Hi

Try with the command:

docmd.RunCommand acCmdSaveRecord

 

[Frothingslosh]

You can also use Me.Dirty = False

 

[Tompen]

Great! I tried the Me.Dirty = False and it worked like a charm! Many Thanks!