Multiple actions for one button

A

Allison

NOTE: This was posted previously, but no solution was found. Original
message is here: http://tinyurl.com/cp9ngx. Thank you for any help you can
provide.

Access 2003, Win XP

What is the best way to accomplish this? Would you please refer me to a
sample code if that's involved?

I'd like the user to press a button that:

1. Deletes the currently-displayed record (displayed in a form with a query
based off of tblDedInfo), and
2. Sets the "fldUsed" field in a different table (tblDedCodes) for a joined
related record. (This was the subject of some discussion; see above link
for resolution.)

Further info: The two tables are joined one-to-one on "fldDedCode" with
referential integrity enforced.

Thank you for any assistance you provide.

Allison
 

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

Similar Threads

Delete record from one table, set field in another table to no 5
Cannot Change Back to Previous Settings After Clicking "Try the new Outlook" 0
How can the font and size of (all) citation numbers be altered? 1
New computer, how do i move outlook 365 ENTIRELY? 0
This Is A Head Scratcher 5
OnChange event delete records 8
Entering data in a field enters the same data in other forms/field 2
Events do not fire when assigning a value to a control using vba 3

Top