How to Unbind a Form from Table

  • Thread starter malik via AccessMonster.com
  • Start date
M

malik via AccessMonster.com

Hi

How Can I Unbind a Form from Table?

And I want to add a Save Button to Post Data into Tables.

Thanks
 
G

Golfinray

A form BOUND to a table will automatically save information entered in the
form to the table it is bound to. To unbind the form you can change the
control source of the form to something else, like a query, then use the
command button wizard to set up a command button to save it in the table you
want.
 
A

Allen Browne

1. Open the form in design view.

2. For all controls, clear the Control Source property (Data tab of the
Properties box.)

3. Looking at the properties of the form itself (not a text box), clear the
Record Source property.

4. Learn how to write code to handle:
a) inserting new records;
b) retrieving existing records;
c) deleting the right record;
d) determining if any existing controls are modified, and writing the edits
back to the right record in your table;
e) undoing modifications.

Alternatively, use a program other than Access to do all this. You might as
well, as you have just discarded most of the rapid development capability
that Microsoft Access provides.
 
K

Keith Wilby

malik via AccessMonster.com said:
Hi

How Can I Unbind a Form from Table?

And I want to add a Save Button to Post Data into Tables.
Click to expand...

That's rather like replacing the engine in your car with a couple of ponies.

Keith.
 
Top