Saving A Record

  • Thread starter Thread starter Ravi
  • Start date Start date
R

Ravi

Hi All. I must first say thanks for all the help in the
past. I need some assistance. The Problem: On my
customer form, the user checks to see if a customer exist
by typing the SSN. If the customer does not exist the
user adds the customer. To do this the user clicks add
record, the fields clear and user can add record. Then
the user clicks save and the ssn is saved to all ssn field
in the all the tables. I want the user to be reminded or
forced to click the save button before doing anything else
or be prompted that the record will not be saved. In this
database only one person can add records and the user has
not been clicking save thus when other users attempt to
access the record it is not available in their sections.
Any assistance will be greatly appreciated.

Thanks
Ravi
 
In Access bound forms, records are automatically saved when you move off the
record to another existing one, or to a new one, or close the form in which
you entered the record. Why not just put the code to create the related
records with the same ID in the AfterUpdate event of the form used to enter
the record and eliminate the "Save" button entirely.

And, if you aren't using bound forms, you're letting yourself in for a lot
of extra work, reimplementing functionality that Access has built in and
does _for_ you with bound forms. And, if you are not using bound forms, it's
not going to be as easy, and would depend on the code you have written to
save the record...

Larry Linson
Microsoft Access MVP
 
Back
Top