EmergentGuru
Registered User.
- Local time
- Today, 07:33
- Joined
- Jul 21, 2016
- Messages
- 18
Hi, I was wondering if it is possible to mimic through text box the record selector on a subform to the body of the subform in an unbound text box etc. The purpose is below:
I have a Form with a subform attached to that. We can call these "Main Form and Subform". Now the record selector in the subform for each record is unique and sequentially chronological in format naturally. (FYI the subform may be continuous where the records are displayed in vertical order. ie you can scroll down and see each different sub form line item within the main Form ID). Along with the record selector at the bottom, I would like to show each line item/record number in the form body to display that particular item number as it would show in the record selector below.
Currently the Subform Auto ID Number is in sequential order but stays connected when going from Subform record to subform records. Meaning, for example the first main record with subform would have 3 subform records numbered 1-3. But when you scroll to the next Main Form Record the subform Auto ID field number continues in that order for and for example will show the first record as 4-6 (given three records again). That does make sense to me.
What I want is an unbound text field notation that would show that same single number in the record selector in the body. The end goal would be to combine that number with a stringed unique value nomenclature identifying each particular Subform item. Example (String Facilities-01/01/15-1-1. (The date, first 1 and second 1 can change based on actual record)
I have a Form with a subform attached to that. We can call these "Main Form and Subform". Now the record selector in the subform for each record is unique and sequentially chronological in format naturally. (FYI the subform may be continuous where the records are displayed in vertical order. ie you can scroll down and see each different sub form line item within the main Form ID). Along with the record selector at the bottom, I would like to show each line item/record number in the form body to display that particular item number as it would show in the record selector below.
Currently the Subform Auto ID Number is in sequential order but stays connected when going from Subform record to subform records. Meaning, for example the first main record with subform would have 3 subform records numbered 1-3. But when you scroll to the next Main Form Record the subform Auto ID field number continues in that order for and for example will show the first record as 4-6 (given three records again). That does make sense to me.
What I want is an unbound text field notation that would show that same single number in the record selector in the body. The end goal would be to combine that number with a stringed unique value nomenclature identifying each particular Subform item. Example (String Facilities-01/01/15-1-1. (The date, first 1 and second 1 can change based on actual record)