Switching backend mdb

[June7]

You want to filter form to selected year then further filter for a record in that year? You want to prevent form navigation to prior years? I don't do this in my db. I have the form RecordSource order records descending by date so the most recent show at top but users can scroll to older records. Maybe someday the dataset will be big enough to cause slow performance on this form and will have to change but don't expect that to happen for a long time. The form has a search utility to allow entering record ID for any year record. This is not a data entry form, it is a search/view only and task execution form.



Are you using form/subform arrangement? Where is OpenArgs set?

If you want to provide db for analysis, follow instructions at bottom of my post.

EDIT: now see your new post. I didn't notice the variable was declared a string, assumed RetYear was number field. I prefer apostrophes, easier for me to read:

Me.Filter = "RetYear = '" & CurYear & "'"

[GraeagleBill]

App not quite the same as I'm understanding your to be. In my app, there are two forms, one continuous where the Roster is shown and the second where the user has double-clicked the selection bar for an individual to view the details for the individual. While in the second form, the user might want to see the details pertaining to another year. In that case, I change the filter based on a drop-down year selection and requery the RecordSource for the form.

As an aside, the form titles include the currently selected year. Is there a way to suspend the first form at the DoCmd.OpenForm of the second so the first form can reset the caption of the first forms title line? OR, I seem to recall there's a syntax whereby the second form can make that change when one occurs. Something like referencing a control on the first form via the forms collection????

And yes, when we've exhausted our discussion, I'll mark the thread "solved".

[June7]

If I understand, you want to reset the form's Caption property. Easy to do with VBA.

If you put the code behind the form whose caption you want changed, simply:
Me.Caption = "something"

Instead of literal "something" can be reference to control on form or VBA variable.

Sorry, I marked this thread solved a lonnng time ago when I thought the issue was solved by the initial suggested code. Just didn't bother to unmark it when we continued.

[GraeagleBill]

Just two minutes ago I finally remembered where I'd successfully changed the value in a control from within one form upon another. Not a true Parent/child relationship, just one of those situations where I know the target form is open and safely change one of its controls.

I think this concludes our conversation about the original post and related issues that evolved. You've been really super with all your help and I appreciate that immeasurably.

As you say, the thread is already marked "Solved", so we can leave it as such.
Thanks again,
Bill