Continuous form not updating table

[mcomp72]

I have a continuous form, but when I make a change to it, it doesn't update the table that is tied to it. I decided it was easiest to make a video showing what was happening.

I'm new to Access & databases, so I'm guessing the fix is something really basic that I don't know about yet.

 

[Gasman]

Record has not been saved yet?
Move to a new record and see what happens then.

Excellent description of issue BTW

 

[mcomp72]

Ah... yes, that was it. When I clicked into another record on the form, that fixed it.

Is there a way to have Access update the record immediately after the user clicks into a checkbox? I am guessing I could put some VBA code into the AfterUpdate sub, but I'm not sure what code I would put in.

 

[mcomp72]

I did some digging around the internet and found the code. If I put the below code in the AfterUpdate sub, it solves the issue.

If Me.Dirty Then Me.Dirty = False

Thank you for the help!

 

[CJ_London]

Just curious - what if the user has clicked a checkbox, and the clicks it again - what do you want to happen?

 

[mcomp72]

Just curious - what if the user has clicked a checkbox, and the clicks it again - what do you want to happen?

When they click that checkbox, it will trigger some code to make a change to another YES/NO field on the Member table called "CurrentOnDues". If they have checked the "Board Member" checkbox, "CurrentOnDues" should change to True. If they have unchecked the "Board Member" check box, it should run some other code. In that case "CurrentOnDues" could be True, but also could be False, so it has to check the date in the "LastDuesPaid" field to determine which it is.

 

[CJ_London]

Sorry I asked
I’m sure it makes sense to you but without any context, not to me

I was thinking along the lines of if the user unticked the checkbox, does the record need to be deleted?

 

[mcomp72]

My continuous form doesn't allow new records to be created. So I don't think there is a worry of an empty record being saved. Unless I am not properly understanding what you mean.

If you go to :17 of the video I posted in the first post, you'll see the form. The only way the user can create a new record that would appear on that form is by clicking the ADD MEMBER button. That will open another form where they can type in data for a single record, but only that one record. There's a SAVE button on that they must click before the record is saved. There's also a CANCEL button, which will disregard anything they've typed into the form.