Hi

The brevity of your post is impressive but is a little limiting when it comes to providing you with proper advice. So posting the code behind the Save button would have made things a whole lot clearer and if my response is not helpful in solving your problem, then I suggest you actually post your code.

However, I think I get the gist of what your problem is so, ignoring the obvious question as to why you would want to torture yourself in this way 🙂 lets see what I can come up with.

To update the database manually the code behind the Save button will need to build and execute an SQL string. The simplest way to build you string is to simply use the Access Query function - but wait, you are using an ADP file (another obvious "why" question there) so I don't think that is going to work. You will need to include the control(s) from the form as the value(s) - me!ControlName should work unless the control is on a subform.

If you are doing record updates from this form, you will need to program both an append query and an update query (maybe use different buttons) - and then of course you might need to perform deletes in which case you will also need to build a delete button and appropriate code.

I hope this gets you started. If you have never created SQL strings in VB before, have a bit of a read and give it a go, but post back if you have trouble (post your code too) and I'll give you some tips on how to go about it.

Cheers

Rowan