I have a table that displays a single record from a table. After I make my changes to the data I want to have that data populate a different table. Any ideas?
I have a table that displays a single record from a table. After I make my changes to the data I want to have that data populate a different table. Any ideas?
query.
use an update query to modify item from form.
update table set [myfield] = forms!myform!txtBox