Microsoft Access Tips | How to EDIT Records using VBA Recordsets

[@easyspeak101]

Thank you! 👍👍

[@wiiiiing]

Thank you for the video. The code works fine, until I set the openform property to open in dialog mode. Besides, I see in your video that the ID field is grey out. May I know if there is any extra setting?

[@wimschiphorst8541]

I saw in your video about adding a new record you made a global module. In this video you make a recordset again. I thought, as you mentioned in te adding a new record video, the point of a glo al module is to be efficient in your coding. Why here building a record set again at the edit onClick button. Is it not possible with some code to call the global module for editing the tabel with the recordset code already excist there?

[@abhishekdhamanse]

Showing Run time Error 3265 with similar code

[@DrMohamedMostafaElboraie]

Please make another series access application by vba code ...i wainting for yiu

[@LoopLearnings]

Sure, very soon !

[@wimschiphorst8541]

I think it is possible to put a code for refresh the form. I think something like. Forms!FormsList!Refresh

[@LoopLearnings]

Yes it is definitely possible