Hello everyone,
I have a form which is formed by a table and I associated a text which will always appears when I add a new record.
The way it works the text is like this:
Also, it was solved in this forum two weeks ago (https://www.accessforums.net/showthread.php?t=75591)
Code:
Private Sub Form_Current()
If Me.NewRecord Then Me.OBSERVACIONES = Dlookup ("texto", "Table")
End Sub
The problem I am facing is when I browse through all records, especially by using "Go to the next record" a new blank record is created when I click on it (when I am at the last record) and that is what I do not want in my application. I suppose that having this default text is enough to create the record.
Is there anything I can do in order to stop this?
I am thinking of adding like a message to confirm if a new record is introduced and it must be accepted in order to create the new record.
Thank you in advance,
Regards.