Requery & New Subform Record

[Kila]

I have 2 problems I hope SOMEONE can assist me with. Briefly, here is the situation...

I have a survey database with 2 subforms, A & B. Subform A has a subform...Asub1

Subform Asub1 lists questions, 1 per record based on the survey selected in it's parent, subformA. Neither of these is bound to the main form.

Subform B has a combo box that lists possible answers for the questions in subformAsub1 (based on a query), and saves the answer selected in another table. It is linked to the main form by a CompletedSurveyID.

Here are my 2 questions:

1. How can I get the combo box to requery?
I have tried this a number of ways, (OnClick, etc.) but everything I try either does not work or the answers are a question behind. Currently, BeforeInsert works, but you have to select twice...the 1st time to create the new record, the second time to save.

2. How can I get subformB to automatically go to a new record when subformAsub1 does?
Again, I have tried the code a number of different ways, but it does not do anything at all. Am I missing something?

Can anyone help? Thanks for looking at the problem.

 

[Jack Cowley]

Your problem probably lies in how you are referring to the controls on the form, subform and subsubform. Take a look here for the correct syntax you need to refer to the controls.

hth,
Jack

 

[Kila]

OH, that is * SO * helpful! Please feel free to share any other handy-dandy websites you are aware of! I will try these. THANKS!!!

 

[Jack Cowley]

If you don't already search the MS Knowledge Base for answers to Access questions then you might want to take a look. You can start by going here.

Good luck!

Jack