Link to home
Start Free TrialLog in
Avatar of davetough
davetough

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of Runrigger
Runrigger
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial