asked on 9/9/2013

Access save bound form record

I have this: -

 If Me.Dirty = True Then
  DoCmd.RunCommand acCmdSave
 End If

Open in new window

It gives error 2455 "You entered an expression that has an invalid reference"

I am trying to get a bound form to save after a box is ticked. Can anyone help?

VB Script Microsoft Access

Last Comment

mbizup

9/9/2013

Gustav Brock

9/9/2013

Try with:

If Me.Dirty = True Then
Me.Dirty = False
End If

/gustav

mbizup

9/9/2013

Try acCmdSaveRecord

If Me.Dirty = True Then
  DoCmd.RunCommand acCmdSaveRecord
 End If

Open in new window

HKFuey

9/9/2013

ASKER

Sorry for not being clear, it errors on line 1

If Me.Dirty = True Then

SOLUTION

IrogSinta

9/9/2013

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

mbizup

9/9/2013

Where is your code located?

If it is not on the form, you'll need the full reference:

Forms!YourFormName.Dirty

HKFuey

9/9/2013

ASKER

Hi mbizup,

Tried the form name, I still get the error, if I take out the if statement and just leave: -

DoCmd.RunCommand acCmdSaveRecord

It seems to work OK

ASKER CERTIFIED SOLUTION

mbizup

9/9/2013

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

mbizup

9/9/2013

Just for kicks, try the same thing on a new (or different) form.