The continuous is not working.
Subform1 has
HelpIndexSubform
Source Object - HelpIndexSubform
Link Master Fields - SubCategory
Link Child Fields - SubCategory
HelpIndexSubform
Record Source - HelpFileIndexQry
Record Set Type - Dynaset
Default View - Continuous
HelpFileIndexQry
SELECT POSHelpFile.POSHelpId, POSHelpFile.Category, POSHelpFile.SubCategory, POSHelpFile.Topic
FROM POSHelpFile
ORDER BY POSHelpFile.Category, POSHelpFile.SubCategory;
---------------------------------------------------------------------------------------
Subform 2
HelpDescSubform2
Source Object - HelpDescSubform2
Link Master Fields - SubCategory
Link Child Fields - SubCategory
HelpDescSubform2
Record Source - HelpFileFrmQry
Record Set Type - Snapshot
Default View - Single form
HelpFileFrmQry
SELECT POSHelpFile.POSHelpId, POSHelpFile.Category, POSHelpFile.SubCategory, POSHelpFile.Topic, POSHelpFile.Keywords, POSHelpFile.Description, POSHelpFile.Image, POSHelpFile.Image.FileData, POSHelpFile.Image.FileName, POSHelpFile.Image.FileType, POSHelpFile.DateCreated, POSHelpFile.DateModified
FROM POSHelpFile
ORDER BY POSHelpFile.Category, POSHelpFile.SubCategory;
Can anyone in the community help me please
Subform1 has
HelpIndexSubform
Source Object - HelpIndexSubform
Link Master Fields - SubCategory
Link Child Fields - SubCategory
HelpIndexSubform
Record Source - HelpFileIndexQry
Record Set Type - Dynaset
Default View - Continuous
HelpFileIndexQry
SELECT POSHelpFile.POSHelpId, POSHelpFile.Category, POSHelpFile.SubCategory, POSHelpFile.Topic
FROM POSHelpFile
ORDER BY POSHelpFile.Category, POSHelpFile.SubCategory;
---------------------------------------------------------------------------------------
Subform 2
HelpDescSubform2
Source Object - HelpDescSubform2
Link Master Fields - SubCategory
Link Child Fields - SubCategory
HelpDescSubform2
Record Source - HelpFileFrmQry
Record Set Type - Snapshot
Default View - Single form
HelpFileFrmQry
SELECT POSHelpFile.POSHelpId, POSHelpFile.Category, POSHelpFile.SubCategory, POSHelpFile.Topic, POSHelpFile.Keywords, POSHelpFile.Description, POSHelpFile.Image, POSHelpFile.Image.FileData, POSHelpFile.Image.FileName, POSHelpFile.Image.FileType, POSHelpFile.DateCreated, POSHelpFile.DateModified
FROM POSHelpFile
ORDER BY POSHelpFile.Category, POSHelpFile.SubCategory;
Can anyone in the community help me please