Thanks for your help daklem but i have figured it out. Im remembering stuff I learnt at school. I just set the form to Data Entry and all is good now :)
Thanks again
thanks daklem but it didnt work. I am opening the form from another form. My code is as follows:
Private Sub Add_Record_Click()
On Error GoTo Err_Add_Record_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmAddRecord"
DoCmd.OpenForm...
Hi all. I know this is a stupid question but currently I have a database that allows you to add a record using a form. My issue is when I open the form up, there is already data in all my fields, so when I overwrite the fields the previous record is removed from my database. Is there a way to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.