Need to create a form for completing a survey

[Simon_MT]

This is the pain of Tabs on subForms. You can only add them in the black portion on the Tab and then adjust the position and size once the SubForm has been dropped on the Tab. This is one of the pleasures of Tabs, Tabs have a feeling of being a bit of an after-thought.

Placement eslewhere will cause overlap, it happened to me until I realised how fickle the Tab were.

Simon
[FONT=&quot][/FONT]

 

[Munkyjay]

I guess I wasn't quite as patient as you in trying to use them! So what do the hidden fields on the main part of the form do? And how do you make the form appear blank until an offender is chosen?

 

[Simon_MT]

There are two ways to force the parent /child relationships.

Method 1) Make a Text box on the Parent for Each Report Section so

S1 = 1 Links with Section 1
S2 = 2 Links with Section 2
S3 = 3 Links with Section 3 etc.

Obviously you also need to include the Offender.

I don't make them appear until the Offender is chosen. I preselect the Offender using a Search feature. The logic is that if the offender is already entered it becoause immediately obvious.

Simon

 

[Munkyjay]

Hi again!

Back in the office now and picking up my messages. So the text boxes on the side of the parent are just there for the subforms to use and identify which questions to display? Like in a query, I would select 'section' and then have criteria set to '1' (for example) - this then shows all the questions in section one. The text fields are there as a reference point?

And how does that tie in with the following bit of code:

Function Quips_Questions_Populate()
With CodeContextObject
If .[Quips_Status] = "U" Then
DoCmd.GoToControl "Offender_Name"
DoCmd.SetWarnings False
DoCmd.OpenQuery "qry_Quips_Questions_Populate"
DoCmd.Close acQuery, "qry_Quips_Questions_Populate"
DoCmd.SetWarnings True
.[Quips_Status] = "P"
.[Populate].Visible = False
DoCmd.Requery
End If
End With
End Function

Is that to populate the parent form with the basic QUIPS/Offender data?