OK, I've scoured the forums and read all the help in access I can read but I can't quiet come up with my solution.
I simply want to statically assign a field in my table from a text box after I go to a new record. In other words, my form opens... I type text in a box that is bound to a field, I go to my next record and it magically appears again and again. (sarcasm after a day of pulling my hair out). I can do it all day long by putting text in the default value properties box but I need to do it at run time because each day it changes and I don't want to type it in 100 times. I tried doing with code from examples on this forum. It worked but only for 1 record. I could not globally set the default value of that text box at run time for some reason.
any suggestions?
I simply want to statically assign a field in my table from a text box after I go to a new record. In other words, my form opens... I type text in a box that is bound to a field, I go to my next record and it magically appears again and again. (sarcasm after a day of pulling my hair out). I can do it all day long by putting text in the default value properties box but I need to do it at run time because each day it changes and I don't want to type it in 100 times. I tried doing with code from examples on this forum. It worked but only for 1 record. I could not globally set the default value of that text box at run time for some reason.
any suggestions?