[AccessD] Synchronizing two subforms

Bill Benson bensonforums at gmail.com
Wed Apr 12 12:01:15 CDT 2017


Rocky, can the right-hand form be filtered to just the active record on the
left form? If so, I would actually put it under the 1st continuous form,
and in the On_Current event of the 1st child form, refresh the 2nd child
form.

On Wed, Apr 12, 2017 at 12:38 PM, Rocky Smolin <rockysmolin at bchacc.com>
wrote:

> Dear List(s):
>
>
>
> A client has a requirement for a Gantt chart which would be a piece of cake
> to automate out of the back end - the first six columns would be frozen and
> so scrolling to the right would keep those first six in view.
>
>
>
> However, he wants it in a form inside the front end.  So my first design
> thought was to make two continuous sub-forms - the left one would be the
> first six fields, the right one would be dates with colors and notes
> describing the status of various tasks.
>
>
>
> The records to be displayed are courses given all over the country for
> CPA's
> continuing education.
>
>
>
> The problem is that as the left subform was scrolled vertically to show
> more
> courses, the right one should keep pace so the records on either side stay
> aligned.  But I'm not sure how to do that.
>
>
>
> Or is there's another approach using one form but would keep those first
> six
> fields on the display while the user scrolled to the right to display more
> calendar.
>
>
>
> Any ideas?
>
>
>
> MTIA,
>
>
>
>
>
> Rocky Smolin
>
> Beach Access Software
>
> 760-683-5777
>
>  <http://www.bchacc.com> www.bchacc.com
>
>  <http://www.e-z-mrp.com> www.e-z-mrp.com
>
> Skype: rocky.smolin
>
>
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list