Re: Spontaneous loss of subform bookmarks

Ah: by bookmark you are referring to the current record of the subform (not
its Bookmark property.)

Someone may correct me, but I do not believe the connection to the data file
should time out if you have a bound form open.

Is there anything else that could be triggering this?
Code in the Timer event of a form?
A Requery somewhere?
Some event procedures that trigger dependencies?
Conditional Formatting?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Tim" <timgstevens@xxxxxxxxxxx> wrote in message
news:1133277925.583379.302050@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> The network is as stable as they get. It doesn't co-incide with network
> errors. I've always put it down to something happening on the local
> machine.
>
> I'm definetly not conciously causing the default workspace to close, I
> guess if this were happening then it would be associated with a bunch
> of error messages and that's just not happening. After its happened if
> you go to the top level list and reselect the line you were working on
> then the event code kicks in and causes all of the subforms to become
> realigned.
>
> Am I truly unique???
>
> Tim


.

Relevant Pages

  • RE: Disappearing data in sub-form
    ... Are you receiving any error messages, or do you see any status bar ... If the subform is based on a query, is the query updateable and can you ... box is likely unbound (ie. it has no Control Source specified). ...
    (microsoft.public.access.forms)
  • Re: Validation Rule on Table Field vs Form Control
    ... happens when you go from a main Form to the Form embedded in a Subform ... protect your users from unfriendly error messages, ... validation in VBA code in the AfterUpdate of Controls on the Form. ... they're trying to exit another control to get into a subform. ...
    (comp.databases.ms-access)
  • Re: multiple users - refresh form
    ... Take a look at the Bookmark property in the Help file, ... The only issue I have now is that when it does refresh it unfilters my ... Is there a way I can also have it requery the data based on the combo ... Torefreshthe data displayed on the subform, ...
    (microsoft.public.access.formscoding)
  • Re: Access Error Messages
    ... I have a form that has a subform in it. ... >>Private Sub FEntryDate_AfterUpdate ... >>But it doesn't seem to trigger, I keep getting the standard Access error ... >>> There's some code out there that will snoop around the error messages ...
    (microsoft.public.access.modulesdaovba)
  • Re: Cant assign a value ...
    ... Most Access error messages should have attached a caveat that says "The ... in the textbox, or exit the textbox having typed something, or perhaps ... Does this happen when there are already records in the subform, ...
    (microsoft.public.access.formscoding)