Hello,

I have created a database and now I have been asked if it's possible that
once an entry form has been marked 'complete' to purge it into a query. I've
looked for a command, or something similiar, but it seems the 2003 version is
limited.

What I want this command to do is once an 'entry form' has been completed by
a USER, to have that particular entry removed and filed to a query, without
removing the incomplete forms.

What function or command do I use to get this done? I was thinking of
placing a 'button' command labeled 'completed' for the USER to press once
the entry is ready to be filed, and having the command execute the macro, but
I don't seem to find a command for that to happen. I'm not very good at
creating macros if this is what I need to do.

Could you please help?

Thanks,--
Maria

On Apr 3, 10:48 am, Maria <M...@discussions.microsoft.com> wrote:
> Hello,
>
> I have created a database and now I have been asked if it's possible that
> once an entry form has been marked 'complete' to purge it into a query. I've
> looked for a command, or something similiar, but it seems the 2003 version is
> limited.
>
> What I want this command to do is once an 'entry form' has been completed by
> a USER, to have that particular entry removed and filed to a query, without
> removing the incomplete forms.
>
> What function or command do I use to get this done? I was thinking of
> placing a 'button' command labeled 'completed' for the USER to press once
> the entry is ready to be filed, and having the command execute the macro, but
> I don't seem to find a command for that to happen. I'm not very good at
> creating macros if this is what I need to do.
>
> Could you please help?
>
> Thanks,--
> Maria

What do you mean "purge" the entry? Delete it? Or mark it somehow?
or Move it to another table? I would probably just update the record
if certain criteria are met. You can do that with an update query and
conditionals in Macros. But I rarely if ever use them, so you might
be on your own on that part.