G
Gary
I have the following:
a table: tbl_main
a form: frm_main (contains the 2 subforms - see below)
a search form: frm_srch (simply a copy of the frm_main that shows only the
records found)
subform: subfrm_data (has fields to enter/view data)
subform: subfrm_pics (contains 4 OLE boxes to insert pictures)
frm_main is linked to query called qry_main (to simply sort the records in
descending manner. Subfrm_data is also linked to this query).
When you open the main form (frm_main) there is a search macro button to
allow the user to type the JobNo (from a dialogue box prompt) and then it
simply opens the form called frm_srch where it finds the record shown in
subfrm_data and the respective pictures associated with the record in the
subfrm_pics.
The problem: when I open the main form (frm_main) and just use the
navigation arrows to view record after record (not using the search macro),
the pictures associated with any given record do NOT show up in the
subfrm_pics.
But the pictures do show up when I use the search macro to open the
frm_srch.
How can I view the main form with all records present (with the navigation
bar) that also show the pics associated with any given record?
a table: tbl_main
a form: frm_main (contains the 2 subforms - see below)
a search form: frm_srch (simply a copy of the frm_main that shows only the
records found)
subform: subfrm_data (has fields to enter/view data)
subform: subfrm_pics (contains 4 OLE boxes to insert pictures)
frm_main is linked to query called qry_main (to simply sort the records in
descending manner. Subfrm_data is also linked to this query).
When you open the main form (frm_main) there is a search macro button to
allow the user to type the JobNo (from a dialogue box prompt) and then it
simply opens the form called frm_srch where it finds the record shown in
subfrm_data and the respective pictures associated with the record in the
subfrm_pics.
The problem: when I open the main form (frm_main) and just use the
navigation arrows to view record after record (not using the search macro),
the pictures associated with any given record do NOT show up in the
subfrm_pics.
But the pictures do show up when I use the search macro to open the
frm_srch.
How can I view the main form with all records present (with the navigation
bar) that also show the pics associated with any given record?