G Guest Aug 6, 2006 #1 How can I use the value entered from a previous field and record to populate the current field?
A Armen Stein Aug 6, 2006 #2 How can I use the value entered from a previous field and record to populate the current field? Click to expand... You can press Ctrl-" on your keyboard to do it manually.
How can I use the value entered from a previous field and record to populate the current field? Click to expand... You can press Ctrl-" on your keyboard to do it manually.
A Allen Browne Aug 6, 2006 #3 Armen has probably given you what you wanted, but here's a couple more options. If you want it to automatically default to the last entry for that field, see: Carry current value of a control to new records at: http://www.mvps.org/access/forms/frm0012.htm If you wanted all controls to default to the previous values, see: Assign default values from the last record at: http://allenbrowne.com/ser-24.html
Armen has probably given you what you wanted, but here's a couple more options. If you want it to automatically default to the last entry for that field, see: Carry current value of a control to new records at: http://www.mvps.org/access/forms/frm0012.htm If you wanted all controls to default to the previous values, see: Assign default values from the last record at: http://allenbrowne.com/ser-24.html