Hi
I've been assigned to fix a access form/db app and i've been stumped on simple problem.
I have a table say table1 with column a,b,a1,b1 and a textbox
i want to set the source control of that textbox to a1 and load the value of "a" into the textbox when the form loads using
form_load
me.textbox.value = dlookup("[a]","table1", query)
and once the form is finished, the value stored on that textbox will automatically be updated into the source control which is the colum a1. But I am having problem acheiving this ? THe database simply wouldn't update. Anyone have a suggestion or a better solution to this ?
THanks, Dave