12-14-07, 14:01 #1Registered User
- Join Date
- Dec 2007
Unanswered: Changing something when changing to new rec
Is there a way in Form view to identify that something has been changed to a new record either by scrolling the mouse or by search button?
I'd like to do a simple...
Me.WhatCategory.Visible = False
...when changing to a new record.
Looking through the event list on the entire form. I don't see a "On Change to new Record" which is what I really need. Or is it named something that I'm just not seeing?
Shoot, no way to delete. I just figured out it is the On Current which I'm already using to display it when its needed to, just in the other cases I need to tell it to hide. Brain fart.
Can you delete a thread you posted?
Sorry for a dumb post.
Last edited by rjwebgraphix; 12-14-07 at 14:11.
12-14-07, 16:30 #2Moderator
- Join Date
- Dec 2004
- Madison, WI
You can test if the autonumber field is null - if isnull(me!MyAutonumberField) then... or utilize the if me.NewRecord then...
(in the OnCurrent event)
Not a dumb post.Expert Database Programming
MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)