Solved

displaying number of records on form

Posted on 2011-02-10
2
258 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
[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
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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

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…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

617 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