R
Robert Robinson
I have created a form which has a main sheet (with lease header information)
and a subform (which has lease detail information). I have established the
necessary one-to-many relationship between the header and the detail. The
detail will often consist of 50+ lines, so I created a macro which updates
the detail table directly. The macro works perfectly; the problem is with the
subform. The subform does not display the lines that have been added to the
base table. From what I can see, the subform perform a query to set up the
fields allowing user entry; however, it does not refresh when data is entered
into the table by means other than entry through the form (subform). Is my
understanding correct? If so (or not), what is the most efficient way to
refresh the subform so that it reflects the imported data?
and a subform (which has lease detail information). I have established the
necessary one-to-many relationship between the header and the detail. The
detail will often consist of 50+ lines, so I created a macro which updates
the detail table directly. The macro works perfectly; the problem is with the
subform. The subform does not display the lines that have been added to the
base table. From what I can see, the subform perform a query to set up the
fields allowing user entry; however, it does not refresh when data is entered
into the table by means other than entry through the form (subform). Is my
understanding correct? If so (or not), what is the most efficient way to
refresh the subform so that it reflects the imported data?