Solved

displaying number of records on form

Posted on 2011-02-10
2
255 Views
Last Modified: 2012-05-11
hello,
i have attached example:
I am trying to display the number of records in Table2 on my Form-( that opens when you open database).
I have created a query 'qryCount' to find number. I created a form 'frmSub based on that query to use as sub form.
When user scans in number - if number is in Table2 - a box comes up says ok-
and a number is generated in number of scans- and number is also inputted into TableCopy.

if number not in Table2-message box says does not exits and number is not increased and number still goes into TableCopy.
PROBLEM: when I add subform to form to display count- it makes the scan number incorrect- Not sure how to make it work-Thank you,


T-DB.mdb
0
Comment
Question by:davetough
2 Comments
 
LVL 11

Accepted Solution

by:
Runrigger earned 400 total points
ID: 34864036
enter this as the control source of the "no of scans" field;
=DCount("[serial number]","Table2")
0
 
LVL 12

Assisted Solution

by:rgn2121
rgn2121 earned 100 total points
ID: 34864074
If you need to get the count of the recordset for the subform, you can use
me.recordsetclone.recordcount
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of utilizing SQL Server functions 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 Ac…
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…

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