Run three dbpQueries from the same Access table and show results in three different Rectangles.

#1 · November 2, 2026, 1:41 pm

I have used "GoSub" from the Page Enter properties and the answer is cleared when the next GoSub is run, even with the data shown in a different Rectangle.

:Geno_Birth
dbpSetGridProperties "GOON" "GRO" "ReadOnly=Yes;ShowNavigationBar=No"
dbpSetColumnOrder "GOON" "GRO" "E_YEAR;SURN_SN_Name;MID_SN_Name;GIVN_SN_Name;DATE_ST_Dateofbirth"
dbpSetColumnWidths "GOON" "GRO" "SURN_SN_Name=75;GIVN_SN_Name=75;MID_SN_Name=75;DATE_ST_Dateofbirth=75;E_YEAR=75"
dbpSetColumnTitles "GOON" "GRO" "SURN_SN_Name=Surname;GIVN_SN_Name=Given Name;MID_SN_Name=Middle Name;;DATE_ST_Dateofbirth=Date of birth;E_YEAR=Year"
dbpQuery "GOON" "GRO" "SUBCAT = [#34]Birth[#34]"
dbpSort "GOON" "GRO" "AFN_R=ASC"
dbpShowGrid "GOON" "GRO" "Rectangle106"
Return

The Three GoSub are Gen0_Birth, Geno_Marriage and Geno_Death. Each works but not together.

Is this possible?

Run three dbpQueries from the same Access table and show results in three different Rectangles. - Forum

Run three dbpQueries from the same Access table and show results in three different Rectangles.