I have a form with 2 subforms. Subform 1 is a continuous form and subfor 2 is a single form (1 Viewer)

atrium

Registered User.
Local time
Tomorrow, 05:56
Joined
May 13, 2014
Messages
348
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
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 02:56
Joined
May 7, 2009
Messages
19,169
add unbound texbox to Mainform.
on Current event of subform2, set the value of unbound textbox to its subcategory

private sub form_current()
me.parent.unboundtextbox=me.subcategory
end sub

now, on subform1 make the unbound textbox the Link Master fields.
 

Users who are viewing this thread

Top Bottom