Subform behavior workaround?

Subform behavior workaround?

Post by Pamela via » Sat, 30 Jul 2005 22:55:53


My project is almost done but there is one little behavior that I don't want
my subforms to do that is driving me mad. I have tried different things to
no avail. Here is the setup:

I have 3 subforms representing 3 tables on a form as detail sections. The
main form itself has fields from the master table (not a subform). The
forms/subforms are separated by page breaks & navigation is via toggle

The problem:

When viewing a detail record on any of the subforms, if the mouse wheel is
moved down, the subform moves to an "empty" record. The record ID remains
the same because it is the ID of the Master record.

What I want to do:

I want to prevent the subforms from going to a "new, blank" record. I have
set the Allow Additions property to "No", but then, when I go to add a new
record on the main form, the subforms do not appear. I have tried to
programmatically get the subforms to "return to the previous record" on the
mouse down event, but I apparently don't know the proper code, apparently,
for simulating the menu command "Edit>Go To>Previous" .

Can anyone help? Still learning VB & have been unable to find this
information on my own.


Message posted via

Subform behavior workaround?

Post by RuralGu » Sat, 30 Jul 2005 23:56:47


Maybe this site will help:

hth - RuralGuy
Please post to the news group so all may benefit.


Subform behavior workaround?

Post by Pamela via » Tue, 02 Aug 2005 23:09:42

Kewl! Thanks! I'll give it a try. :-)

Message posted via