CarryOver information from one control to the nxt record automatic

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to carry over the values in two text boxes for the just saved record
to the new record. I set the value AFTER UPDATE to
Me!txtbox.DefaultValue... etc. and it works for one of the fields. The
second field is a combo box where the bound column is a UserID but I set the
column width to 0 so the user see and can scroll by the UserName. AFTER
UPDATE what is in the control UserID or UserName and how can I carry the
information to the next field so the user does not have to keep keying in the
same information?
 
It should still work for the combo with the hidden bound column.

If you can't get that working, or you want to carry over all controls, see:
Carry data over to new record
at:
http://allenbrowne.com/ser-24.html
The article explains how ot use the BeforeInsert event of the form to drop
in all the values from the last record in the form, so that even works after
the form has been closed.
 
Back
Top