add count to form

when you open db- you will see form- for user to enter data
is there a way - when user enters serial number - the number of serial number already in database displays on the form?
I have a duplicate query - that produces number- but I want it to appear after user enters serial number.
thank you
Database1.accdb
davetoughAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
test this

use this codes

Private Sub serialNumber_AfterUpdate()
Me.Text10 = DCount("*", "table1", "serialNumber='" & Me.serialNumber & "'")
End Sub

Database1.accdb
0
 
davetoughAuthor Commented:
thank you
0
All Courses

From novice to tech pro — start learning today.