Subform behavior workaround?

  • Thread starter Thread starter Pamela via AccessMonster.com
  • Start date Start date
P

Pamela via AccessMonster.com

Hello;

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
buttons.

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.

Thanks!
 
Back
Top