[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 286
  • Last Modified:

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
0
davetough
Asked:
davetough
1 Solution
 
Rey Obrero (Capricorn1)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

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now