Carrying over a form

[NancyLouLou]

I found a very helpful thread on this site and I was wondering if you could help me out a little with it. I've included the link to the thread below. At the bottom of the thread MajP instructed the user to replace part of Allen Browne's code and use the code that you supplied. I followed these instructions in my form and the three fields that I wanted to carry over did so beautifully. However, I noticed that anytime I changed the data half way through data entry, all of the previous records changed as well. Also, the table that this form writes to is showing blank in the three fields that are carried over. Is there anyway around this using this code? I have a supervisor, date and day field that all needs to be carried over until the user manual changes that data. Thanks in advance for your time!

http://www.tek-tips.com/viewthread.cfm?qid=1576940&page=5

 

[dhookom]

Apparently your three controls might be unbound. If you want them to write values to the record source table, they must have a field name as the control source. Then make sure the code sets the default value and not the value.

If you can't figure this out, come back with your code.

Duane
Hook'D on Access
MS Access MVP