smitty27629
Registered User.
- Local time
- Today, 01:38
- Joined
- Jul 27, 2004
- Messages
- 12
I have a form that contains fields that are populated by a query and it has a few fields that require user input. What I'd like to do is have a Save button that when clicked will save all the fields on the form as a record in another table. This form would be used multiple times for each month and year query and each run would need to be saved as a new record in the table.
One way to accomplish this is to have the record source point to the table to save to but the record source specifies the query that populates the form. What do I do now? Would I need to put a query behind the Save button or would I need to put some code behind the button? If code is needed, could someone point me to a sample or example of this so I could accomplish this? Thank you for your help.
One way to accomplish this is to have the record source point to the table to save to but the record source specifies the query that populates the form. What do I do now? Would I need to put a query behind the Save button or would I need to put some code behind the button? If code is needed, could someone point me to a sample or example of this so I could accomplish this? Thank you for your help.
