Steven_Bash
Registered User.
- Local time
- Yesterday, 22:57
- Joined
- May 9, 2018
- Messages
- 27
Hello!
I have this continuous form("billingreport") that has a lot of data grabbed from this query("query1"). The form is reproduced every month with new data values. So I want to 'Save it' with that specific month data being locked in. What I have right now is a cmd button on the form where to save the report, click on it, user input box pops up to name the new copied form then [(what i need help with)cut ties with the recordsource so it does not get updated]. In my mind I saw it as: Copy Form->Lock values of data->Remove recordsource. I haven't figured out a way to do so. Please help!
I have this continuous form("billingreport") that has a lot of data grabbed from this query("query1"). The form is reproduced every month with new data values. So I want to 'Save it' with that specific month data being locked in. What I have right now is a cmd button on the form where to save the report, click on it, user input box pops up to name the new copied form then [(what i need help with)cut ties with the recordsource so it does not get updated]. In my mind I saw it as: Copy Form->Lock values of data->Remove recordsource. I haven't figured out a way to do so. Please help!