asked on New Record
I am using the following to ascertain if a record is new and if so run a requery
Private Sub Combo29_On_Enter()
If Me.NewRecord = True Then
DoCmd.Echo False
Combo29.Requery
DoCmd.Echo True
End If
end sub
Its for when a new record has been entered onto a form a requery updates the combo box with the new record details.
Doesn't work
Private Sub Combo29_On_Enter()
If Me.NewRecord = True Then
DoCmd.Echo False
Combo29.Requery
DoCmd.Echo True
End If
end sub
Its for when a new record has been entered onto a form a requery updates the combo box with the new record details.
Doesn't work
Microsoft Access
Last Comment
IrogSinta
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you both<br /><br />I tried my code in the OnCurrent but it did not work because if a user enters a new record and then moves to another existing record the oncurrent will not know it's a new record and will not fire. So I use the On enter because it only updates the required combo. (There are 4 on this form all used to find existing records.<br /><br />The After Insert would appear to be the answer I will try that.<br /><br />Yep that's got it<br /><br />Can you tell me does after insert fire after each field/control insertion or only when moving to another record
AfterInsert fires when a new record is added. Not when traversing records.
Open in new window