We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Course Of The Month
10 days, 1 hour left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
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
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3
5 Comments
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.
You could also use the form's AfterInsert event for this:
Private Sub Form_AfterInsert()
Combo29.Requery
End Sub
Active 1 day ago
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.
If you are experiencing a similar issue, please ask a related question
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening. This article shows how to create and use them.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship.
Add the tables:
Create the relationship:
Decide if you’re going to set referential integrity:
Decide if you want cascade upda…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month10 days, 1 hour left to enroll
623 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.