And where would you put this code SOrry but my programming skills are still below average. Actually in this case im letting users edit the records not add them because my menu has a button which goes to the same form in add modeYou could use one form to do both editing and data entry. Ex.:
stDocName = "frmBorrower"
DoCmd.OpenForm stDocName
with forms!frmBorrower
.DataEntry = True 'Sets the form in data entry mode for adding
end with
or
stDocName = "frmBorrower"
DoCmd.OpenForm stDocName
with forms!frmBorrower
.DataEntry = False 'Sets the form in edit mode
end with
This part is going to be a problem: "[tblBorrowerDetails.BorrowerTitle]="
It should be "[tblBorrowerDetails].[BorrowerTitle]="
Please review my comments above on this issue.
I'm not sure what you are trying to do with this form. Are you trying to use it to add records or edit records? Why is it named "Add..."?
Ok ill change it but Can you explain why is it going to be a problem? I guess not using the auto-numbered field worked....This part is going to be a problem: "[tblBorrowerDetails.BorrowerTitle]="
It should be "[tblBorrowerDetails].[BorrowerTitle]="
Please review my comments above on this issue.
I'm not sure what you are trying to do with this form. Are you trying to use it to add records or edit records? Why is it named "Add..."?
ACtually its both add and edit but i named it add anyway. My database has a menu that lets users choose to add a record and another button to edit the record later