ImLost
Registered User.
- Local time
- Today, 13:43
- Joined
- Nov 16, 2005
- Messages
- 44
Hello All!
Thanks again for all your help over the years. I have another issue that I hope you can help with.
I have a form that is linked as the many in a one-to-many relationship. On this form, I've used text boxes to link back to a subform of the main form in the relationship. So far, this is all working just great.
My problem is that if the data on the linked form changes, it will change in the text boxes on my new form as well, which will affect the data I'm gathering (which is for a specific time frame based). I was wondering if there is a way to lock a value once it is set, even if it is linked.
For instance - I know in Excel that if you determine a value using a function, you can copy the value to keep the value. Is there a similar option in Access so I don't need to manually enter information that is already in play?
Thanks for any and all assistance you can offer. It's greatly appreciated!!!
Thanks again for all your help over the years. I have another issue that I hope you can help with.
I have a form that is linked as the many in a one-to-many relationship. On this form, I've used text boxes to link back to a subform of the main form in the relationship. So far, this is all working just great.
My problem is that if the data on the linked form changes, it will change in the text boxes on my new form as well, which will affect the data I'm gathering (which is for a specific time frame based). I was wondering if there is a way to lock a value once it is set, even if it is linked.
For instance - I know in Excel that if you determine a value using a function, you can copy the value to keep the value. Is there a similar option in Access so I don't need to manually enter information that is already in play?
Thanks for any and all assistance you can offer. It's greatly appreciated!!!
