troubleshooting Question

iterate through subform fields

Avatar of Hooligan
Hooligan asked on
Microsoft Access
13 Comments1 Solution579 ViewsLast Modified:
I have a form, on which there are 3 subforms.  each subform is in datasheet format, and consists of only a few textboxes and labels.  All the txt boxes are user inputs.  there can be as many new lines of user input as the user wishes.  for example, user1 has 5 items he enters into the subform1.  each item is put into a table with a unique identifier, so it can be called upon later.

I need to iterate through the subform fields (for every line item) everytime the user enters a new line item into the subform.  I tried everything I could think of, but couldnt figure it out.  so i just removed my code and figured id start from scratch.  Im sure its something simple I am missing, but its killing me heh heh.

basically I just need to know how to iterate through a subform's fields.

Any help would be appreciated!


Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 13 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 1 Answer and 13 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