Hi Everyone, i was not able to locate this question in the forms so i apologize if this was asked and answered in the past.
I have a recordset that i open from my SQL Server that i load as the record source to my access form. I need the recordset to stay open while the form is open but once i close the form i need to recordset to close as well so i stop getting the error that says i can't save changes.
What i need to know is how i can reference the recordset in my Form_load sub so that i can close it in my Form_Close Sub.
I have a recordset that i open from my SQL Server that i load as the record source to my access form. I need the recordset to stay open while the form is open but once i close the form i need to recordset to close as well so i stop getting the error that says i can't save changes.
What i need to know is how i can reference the recordset in my Form_load sub so that i can close it in my Form_Close Sub.