As mentioned briefly in a previous post, I have a macro button that executes an append query and then a delete query to "save" records that have been entered into a form - actually, these saved records are within a subform. My problem is that when the macro executes and does it's job, my subform (which is in datasheet view) has "deleted" written across the lines which were moved. That's ok, as I understand what it's telling me. What I want to show is just the blank next line (get rid of those "deleted" lines) - waiting for the next set of entries. I notice that those lines go away if I close and reopen the form, so I've assumed I have to run some sort of repaint or refresh command, which I've been trying to attach to the end of my list of macro commands, but with no luck. I've tried repainting the main form and the subform (Access tells me I have to open it first, which I think I did) and still no luck.
Any thoughts to lead me towards the path of wisdom?
(Hope all you Seattle folks are ok)
Milin
Any thoughts to lead me towards the path of wisdom?
(Hope all you Seattle folks are ok)
Milin