Implement delete and amend query in form

K

Kendra

A further complication to the question I posted 5 minutes
ago.

I have a form in which an administrator can look at the
records added to a database and choose whether to accept
or decline the new record. If he declines the new record
by selecting decline from a pull-down menu, the record
should be deleted. I have built the delete query
(called "DeclinetoDelete")which specifies the record in
the table should be deleted with field AdminApproval
= "Decline". I also want him to be able to send the
record to an AdminApproved table if he agrees with the
record. I am now building an append query, should be
called "AccepttoAppend".

Can someone please give me the VB code to write in the "On
Change" box of the field in the form? And, should this be
added via code builder or macro builder? Sorry about
reposting... I just realized that adding two queries into
a specific command might be quite tricky!

Many thanks,
Kendra
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top