displaying number of records on form

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
davetoughAsked:
Who is Participating?
 
RunriggerCommented:
enter this as the control source of the "no of scans" field;
=DCount("[serial number]","Table2")
0
 
rgn2121Commented:
If you need to get the count of the recordset for the subform, you can use
me.recordsetclone.recordcount
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.