Well, Not really necessary although you can bypass setting the recordset to nothing and will not encounter any error. It is the best practice to set the recorset to nothing after you closed it especially when you have no use to that recordset or you will not going to access the same recordset again.
all thumbs up to the best teacher. already subscribed. thanks for the great tutorial
Thanks for watching.
Thanks 🙏 for the video
Thanks for watching brother.
One more ad. To clean the fields when the form opens. I now made a button for this at the form
Hi, Good Video. One question. After a Set Command here opening a recordset I thought you always must close it. like rs.close set rs = Nothing.
Well, Not really necessary although you can bypass setting the recordset to nothing and will not encounter any error. It is the best practice to set the recorset to nothing after you closed it especially when you have no use to that recordset or you will not going to access the same recordset again.