Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.
Solved
New Record
Posted on 2013-01-01
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
3
5 Comments
Active 1 day ago
Use the form's OnCurrent event instead:
If Me.NewRecord = True Then Combo29.Requery
Active today
I generally use the Form_Current event to test if you are on a new record
Private Sub Form_Current
If Me.NewRecord = True Then Combo29.Requery
End If
And I almost never use the Echo method to prevent screen updates. If I do, I ensure that I have an error handler on that code segment to ensure that if an error occurs, I can set Echo = True in the error handler.
Private Sub Form_Current
If Me.NewRecord = True Then Combo29.Requery
End If
And I almost never use the Echo method to prevent screen updates. If I do, I ensure that I have an error handler on that code segment to ensure that if an error occurs, I can set Echo = True in the error handler.
Active 1 day ago
You could also use the form's AfterInsert event for this:
Private Sub Form_AfterInsert()
Combo29.Requery
End Sub
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
Featured Post
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
When we develop an application in Ms Access 2016 we should also try to protect the queries, macros and table links. I know I may not have a permanent solution but for novice users, they will not manage to break your application. Below is the detail …
If you need to implement application level security in an Access database application or other VBA code, I strongly encourage you to take advantage of Active Directory groups.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks.
Specify a start-up form through options:
Specify an Autoexec macro:
Us…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses
Course of the Month6 days, 11 hours left to enroll
589 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.