troubleshooting Question

How to use the line quantities in the Subform details in VBA array

Avatar of Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.Sc
Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.ScFlag for Zambia asked on
Microsoft AccessSQL
5 Comments2 Solutions27 ViewsLast Modified:
In Ms Access , I have a subform which shows lines quantities, now I want to put these line quantities into an array for further processing , How do I grab those details line quantities ? I have tried to use the code below its bringing nothing:

item.Add "Quantity", Forms!frmCustomerInvoice![sfrmLineDetails Subform].Form.Quantity & "AND ItemesID =" & CStr(i)

Open in new window


Join our community to see this answer!
Unlock 2 Answers and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros