Saving and record sources

[Guest]

Hi, a couple of questions:

Saving:
I have forms with command buttons on, which are used to input data into text
boxes for which the control source is set to a particular part of a table.
This information seems to be saved automatically when i exit the form, so
what is the point of the save command button?
When i then go back into the form, and go to a presaved record, if i press
any of the command buttons, this changes the information in the table under
the relivant record. How can i stop this? eg, when the 'save' button is
clicked on a particular record all other buttons are deactivated and
ammendments cant be made??

Next question:
Using information from more than one table:
On the form properties i can choose which table a form uses as its record
source, however is there any way in which i can get different text boxes on
the same form to relate to different tables??

Sorry if this is a bit long winded, but any help would be great.
Many thanks
Nick

 

[Fred Boer]

Hello Nick:

Question 1:

Access will automatically save changes to a record when you navigate away
from the record, or close the form. A "save" button might be redundant, but
could be used to force a save on demand... Preventing changes to a record
can be done in different ways, depending on your needs. For example a record
may have a boolean field which "flags" whether or not it has been
"presaved". Code could be written to make the form read-only if this flag is
set.


Question 2:

You can use different tables on a form by creating a query which uses more
than one table. Or by using form/subform(s). More details about what you
want to accomplish would help answer the question...

HTH
Fred Boer