New record in an unrelated subform

[Kila]

I have a form that has 2 unrelated subforms. Let's call them SubformA and SubformB. SubformA has a subform of it's own...SubformA-sub1. Subform A-sub1 never makes new records, it only displays what is in each record. How can I get SubformB to go to a new record and refresh it's query whenever SubformA-sub1 goes to the next or last record? Whenever I reference SubformB in SubformA-sub1's OnCurrent, it says SubformB is not open.

Any assistance ASAP is deeply appreciated...I have to get my project working by the end of the day. Thanks.

 

[Kila]

OK...I got it working by putting

cboSubformBID.Requery

Under "BeforeInsert", but now you have to select the answer twice for it to save it. But when I put this command anywhere else (On Click, On Current, etc.) it either does not work at all, or is a record behind the Questions form.

Also, I still need to find out how to go to a new record when the SubformA-sub1 goes to next.

Thanks for your help!