save new record

[shagha]

I've created a macro for saving records, but it's just over write on the previous record, what's the best way to save new records using forms?

 

[rzw0wr]

Access does not need to have a Save button on a form.
Access will automatically save when moving the cursor to a new record.
If the record is not saving properly chances are your tables are not structured properly.

Read up on table normalization.

Dale

 

[missinglinq]

Also note that Access is not a word processor! You cannot edit an existing Record and then 'save' it as a New Record; you have to first move to a New Record then enter your data!