Solved

add count to form

Posted on 2011-03-15
2
274 Views
Last Modified: 2012-05-11
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
Comment
Question by:davetough
2 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 35142075
test this

use this codes

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

Database1.accdb
0
 

Author Closing Comment

by:davetough
ID: 35143858
thank you
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question