Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

displaying number of records on form

Posted on 2011-02-10
2
Medium Priority
?
261 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 1600 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 400 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

580 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