Re: Deleted Records

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Tomas (Tomas_at_Bomba.lt)
Date: 12/29/04 

Date: Wed, 29 Dec 2004 18:10:08 +0200

Try to use Macro Action RunCommand with command Refresh

"Dava Sutts" <DavaSutts@discussions.microsoft.com> wrote in message
news:72914191-CDFB-4581-99F4-9AD6C57A1D00@microsoft.com...
> Hi
>
> I have a simple Form, howver, on 'lost focus' of a check box i run a macro
> which runs an Append and a delte query and then opens another Forms.
>
> Everything seems to work well and the data selected is Appended and delted
> to the correct table....However when i return to the Forms it shows
> 'Deleted'
> in all the fields, it not a major problem, but does nopt look good.
>
> Is there something i can run within the Macro, which refreshes the Form to
> make the records not appear again as 'Deleted'?

Relevant Pages

  • Re: Run macro based on empty field in form
    ... If you don't see the Conditions column in the macro design window, select it from the View menu. ... I have a form where I require a prompt to appear if the chosen foeld is empty upon lost focus. ... I have created a macro to run a simple message box but I do not want it to run if the field is not empty. ...
    (microsoft.public.access.macros)
  • Input Box that allows user to select range
    ... I have a macro that runs normally from the range J2:J100, ... for M2:M100 howver this range can change, i.e. could be J2:J50, and ... not the coulmn!). ... Joseph Crabtree ...
    (microsoft.public.excel.programming)
  • Deleted Records
    ... I have a simple Form, howver, on 'lost focus' of a check box i run a macro ... which runs an Append and a delte query and then opens another Forms. ...
    (microsoft.public.access.forms)