Disabling Ribbon prevents doCmd.SAve (1 Viewer)

Tompen

Registered User.
Local time
Today, 02:21
Joined
Jul 2, 2014
Messages
12
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

Registered User.
Local time
Yesterday, 17:21
Joined
Oct 22, 2011
Messages
139
Hi

Try with the command:

docmd.RunCommand acCmdSaveRecord
 

Frothingslosh

Premier Pale Stale Ale
Local time
Yesterday, 20:21
Joined
Oct 17, 2012
Messages
3,276
You can also use Me.Dirty = False
 

Tompen

Registered User.
Local time
Today, 02:21
Joined
Jul 2, 2014
Messages
12
Great! I tried the Me.Dirty = False and it worked like a charm! Many Thanks!
 

Users who are viewing this thread

Top Bottom