Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to Determine Add New Record Mode
- Thread starter rf222
- Start date
TheAceMan1
Programmer
How are ya rf222 . . .
To know if your editing a new or previously saved record, in the [blue]Dirty[/blue] event of the form:
See Ya! . . . . . .
To know if your editing a new or previously saved record, in the [blue]Dirty[/blue] event of the form:
Code:
[blue] If Me.NewRecord Then
[green]'New Record code[/green]
Else
[green]'Previously Saved Record code[/green]
End If[/blue]TheAceMan1
Programmer
. . . or perhaps
See Ya! . . . . . .
Code:
[blue] If Me.DataEntry Then
[green]'Add New Mode here[/green]
Else
[green]'Non-Add here[/green]
End If[/blue]- Status
Similar threads
