Refreshing SELECT statement on subform

[RA99]

I'd better cut right to the chase with an upload, as it's pretty complicated to explain. The "patient" is form ProgramViewF and subforms. My subforms 2 and 3 are correctly updating the table ProgramRoleT with a basic record, but so far, nothing I have been able to put in the event processing for subs 2 or 3 is able to refresh the (complex) SELECT statement in ProgramViewSubF. As a result I can't add the additional data (start and stop dates) to the underlying data of ProgramViewSubF. Any thoughts how I can force a re-select?

[June7]

Not experiencing the behavior you describe. Both selections in subforms 2 and 3 show immediately in ProgramViewSubF and I am able to enter dates.

[RA99]

In some cases it is working, but ... there's at least one case where it is failing. Find the program "Loak Virsa" (Program ID 91) and try to add a programmer from either subs 2 or 3 or both. They will appear as new records in ProgramRoleT but not in ProgramViewSubF.

[June7]

Nope. No problem with that one either. I did first delete the 3 existing records before attempting to select in subforms.

[RA99]

The problem is that I need to keep all historical records associated with the program as they are used, among other things, for calculating programmer tenure. Can you see anything that might be preventing addition of records?

[June7]

I just added a third record for Loak Virsa. Cannot replicate the issue you describe.

[RA99]

Good grief, what an idiot I am - I shut off the vertical scroll bar!! Sorry to take your time, and glad I did not have a big knarly SQL problem in my hands.

[June7]

And I was idiot enough to think that was intentional!! I should have asked. Glad it is resolved.