Re: Spontaneous loss of subform bookmarks

I tried running with the timer event off and no difference.

The alignment in the subform controls is just about requerying controls
that are based on queries. i.e. At the top level the oncurrent event
will copy the index of the selected record onto a hidden control which
is used as a query parameter for the next level down. So the next level
down subform just needs requerying to align its records to the top
level. The main form is a large tab control with each level on a
seperate tab. It means that the 70% of the whole database is contained
on a single form with a lot of interdependency.

I guess this is pretty inelegant. In my defence I inherited the
database to look after, I didn't create it. Although that said it was
actually created by a software consultant.

Tim

.

Relevant Pages

  • Re: Maximum height of a form
    ... Did you check to see what the nameof the subform CONTROLS are on form ... When you create subform controls, the form used in the subform is NOT open ... I ended up putting a tab control on another form -"Form3" and putting ... Rick B's suggestion of using a tabbed form is the way to go. ...
    (microsoft.public.access.reports)
  • Re: Error 2118
    ... it certainly won't be helped by using a Timer event ... Set row ... > a couple of listboxes that are there to just display data. ... > controls although their source is an SQL statement that includes the ...
    (microsoft.public.access.formscoding)
  • Re: checking whether a record has been dirtied in the last 60 secs
    ... You could use the forms timer event to test the value of the controls after ... I would probably create a user defined data type to store the values of all ... and set the value of some variable (LastChange) as NOW. ...
    (microsoft.public.access.formscoding)
  • Re: Unbound list box in a read only form
    ... lock all the controls on the form who's module it is run from. ... That includes locking the subform controls which in effect locks the controls on the subform's form. ... It's easy enough to unlock a control on the main form. ...
    (microsoft.public.access.formscoding)