Field in one subform auto-updates, other doesn't, wondering why

[cherold]

I have a form with two subforms from which I can open up a form for one of the listed records. These records have a date field which I can update to the current date. In one subform, updating the date causes it to show the new date, while the other will not show the change. As far as I can tell the properties for the two fields are the same.

I'm very puzzled and don't know enough to figure this out. Could it be the relative complexity of the underlying subform queries? Or something in the other forms I'm opening that indicates whether or not related forms should be updated? Or is there a property I didn't notice, or wasn't aware had an effect.

Does anyone have an idea how to figure this out?

[June7]

These subforms are bound to same records? If not, why would you expect entry in one to reflect in the other?

Without knowing data structure and code, virtually impossible to determine nature of issue.

[davegri]

In one subform, updating the date causes it to show the new date

Shows it where? Where you just type it, or WHERE?

while the other will not show the change.

Again, Where should it show?

[cherold]

Sorry, I realized that the file failed to upload and I put in an old version of the file that was already in the upload manager. My internet is wonky or something and I can't upload anything, it seems, so just ignore this until I can try and upload from a different computer. Sorry again!

[June7]

I wouldn't track times listened by incrementing a value in a field. That is saving aggregate data. But it is data that cannot be validated. What if there is accidental click? I would create a record for each time listened then calculate a count based on actual data.

[ssanfu]

There is a form called "What to listen to next."

The form is not in the dB of the attached zip. So... can't tell what the problem is.


There are, however, several errors in the VBA code.........

[cherold]

Doesn't surprise me, but there was an error in the upload and I accidentally used a file I'd uploaded here years ago so it's not relevant to my issue. Although if you feel like telling me what the errors are I wouldn't mind; they're probably are still there. I'm sure my VBA code is riddled with errors.

[ssanfu]

The first error that pops up is in module "ParsePerformer". The top line is "Compare Database". It should be "Option Compare Database".

EVERY module (standard, form and Report) should have

Option Compare Database
Option Explicit

as the top two lines.

In the IDE, click on "TOOLS/Options", In the dialog box, click on "Require Variable Declaration".
This will add "Option Explicit" to every NEW code module.

Add "Option Explicit" to every code module.
Once you add "Option Explicit", do a "Debug/Compile". You will be shown the errors (2 variables not declared - 1 variable misspelling).