Requery Based on a Checkbox
Posted on 2006-06-29
I have a form that contains two subforms. What I am trying to do is have a user select accounts on subform 1 that are delinquent and after they click the box for that record to indicate Yes, I would like the other subform, subform 2, to populate with that account so they can enter the reason it is delinquent. I know I have to use VBA Requery but I can not get it to work. The only way that subform2 populates is if I close and reopen. Could someone advise how to do this? Thank you in advance.