First off, I haven't ever used continuous forms (I personally don't like how they operate or look, but that is my perspective) so I am only guessing at some possibilities. I would try putting a command button on the form and see what happens. If you don't get your results, try putting the command button in the header or footer instead of directly on the form. If none of this works for you, then you might try using google for a solution.
You will need some sort of VBA code similar to:
You will have to list all your textboxes. And most important, this code is untested.
As an aside, will this db be used by someone other than yourself? Will the other users be making edits? If there are no other users than yourself, then why all the precautions? If there are other users who should not be editing information, then perhaps, you should consider not making information available to them through tables, forms or queries which are all editable and giving them only access to information in the form of exported queries to excel or text files or in printed Access Reports -- all of which would not allow updating of your db. Just my thoughts on the whole scheme.
Alan
Bookmarks