K
Kendra
I think this is appropriate to the macro group (since I
think I need a macro to do this).
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".
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?
Many thanks,
Kendra
think I need a macro to do this).
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".
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?
Many thanks,
Kendra