Tab Controll Sub Form Not Working

[extreme]

Hi all I have a form with a tabctl on two of th tabs I have suforms But the subforms is'nt showning the data I have entered.

All I have showing is a white box were the sub form should show.

Please can anyone help me with this as I am confused

Thank You

 

[DCrake]

Simple Software Solutions

Are the subforms related in any way to the parent form? If so have you set the relationship up between them both? Normally when you get a white screen this usually indicates that there is no matching records in the child record source.

CodeMaster:

 

[extreme]

Are the subforms related in any way to the parent form? If so have you set the relationship up between them both? Normally when you get a white screen this usually indicates that there is no matching records in the child record source.

CodeMaster:

Thank you for the reply I'm a noobie to access but I will ry and solve the relationships to see if that is the cause.

Thanks Again

 

[extreme]

Sorry but still having problems I have tried what DCrake said but it seems to be ok.

On my SurveySub On the record sorce I have this which it should work

SELECT DISTINCTROW SurveyDetail.DetailID, SurveyDetail.SurveyID, IIf([NoteNo]=0 Or [NoteNo] Is Null,Null,[NoteNo]) AS [Note], SurveyDetail.Block, SurveyDetail.Floor, SurveyDetail.Area, DecryptTxt([Position],[SurveyID]) AS Location, nz([ProductType])+nz([ExtentOfDamage])+nz([SurfaceTreatment])+nz([AsbestosType])+nz([Occupancy])+nz([Disturbance])+nz([Exposure])+nz([Maintenance]) AS Totals, SurveyDetail.InspectionPointNumber, SurveyDetail.PhotoNo, SurveyDetail.DiagramNo, SurveyDetail.MaterialType, SurveyDetail.Recommendation FROM SurveyDetail ORDER BY IIf(forms!Survey!SortBy=1,Format([InspectionPointNumber],"0000000"),[Block] & [Floor] & [Area]);

But it stills shows a white background and no detail can anyone advise please

Thank You

 

[boblarson]

What is the query for the main form?

What are the current Master / Child links for the subform control on the main form?