I'm curious. That code seems like overkill. Can you explain what clicking the command button does?
Bill Mosca, Founder - MS_Access_Professionals
Microsoft Office Access MVP
My nothing-to-do-with-Access blog
---In MS_Access_Professionals@yahoogroups.com, <firstname.lastname@example.org> wrote :
My problem is solved. Thanks.
I changed the "Me.Requery" into "Me.Refresh" in the Public command button.
Dear All,After running this code, the form keeps blinking without stop. Please help.On Error GoTo ErrHandle
Dim rst As DAO.Recordset
Set rst = Me.subRoomUpdate.Form.Recordset
Do Until rst.EOF
Set rst = Nothing
Resume ErrExitBest Regards,Kevin
Posted by: email@example.com
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (3)|
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? The Yahoo Mail app is fast, beautiful and intuitive. Try it today!