Form reference paths

Allows a much simpler syntax to be used in sql rowsources for controls: eg. Me!txtVisitDate might become [forms]![fmMain]![fsubClient].[form]![fsubClientVisits].[form]!txtVisitDate

Public Function FormReferenceString(f As Form, Optional ParentOffset As Integer = 0) As String

Returns a form reference string from the root to the passed form, or the form (ParentOffset) levels up the hierarchy from the passed form.


Public Function ReplaceFormReferenceKeyword(f As Form, SourceStr As String) As String

Replace the keyword in RowSource sql with the full reference to the passed form. Keywords: [Me] or Me The passed form Keywords: [Parent] or Parent The passed form Keywords: [GrandParent] or GrandParent The passed form Uses the xf.Gen.ReplaceIdentifier method so as not to replace fragments matching the identifiers.