init table values & reset values

[stormin_norm]

It has been a while since I've posted or answered q's at this forum. Wishing all a great New Year! I already searched the forums before posting this thread but did not find exactly what I want to do. PLEASE HELP!

I inherited a DB and found records becoming corrupt. while editing a record, the user can click a button which fires an update query to change the underlying record values

Now I need your help in designing a better way to reset the values. I will provide a record layout. I am hoping I don't have to code each field in VB: Me![field]=dlookup "...."

---------------------------------------------------------------------
The app is a prospect mailing db. There are 20 mailings and some "waiting" between each mailing. Depending on the classification of the prospect, the "waiting" can be 5 days, 10 days, 15 days, 20 days or Custom. Where each of the mailings can me modified by the user. Therefore a "wait" table defines these "default values".
ex:
wait seq1: 5,5,10,5,5,10,2,2,5....
wait seq2: 10,10,15,5,5,10,10,5,5....
wait seq3: 15,15,30,30,5,5,5,....
custom: user defined (2,3,3,2....) or (1,1,1,3,3,....)

Prospect table (pid, fn, ln, etc..)
sequence table (pid, seq#, days01....days20, datemailed01, otherinfo...etc..)
wait table (seq#, defdays1, defdays2, defdays3..)

Q:
The user clicks button to go from frmProspect to frmSeqDetail. Seq2 is the current value of seq#, when user selects cboSequence = "Seq3" all the values should be reset to the values defined in waittable.seq#=3. What is the best way to do this? Do I have to set each value via vbcode? Currently the macro is running an update query while current record is being edited.

THANKS for all guidance!! Obviously I'm starting to over engineer the problem and there is a one line solution.