subforms

  • Thread starter Thread starter Debbie
  • Start date Start date
D

Debbie

In my subform I'm only wanting to be able to insert one
record for each ID in the Main Form. I know that if you
scroll or you have the record navigators on the bottom of
the subform you can go to another subform record for the
same Main Form record. I hid the navigators and you can
still get to it by scrolling your mouse wheel. Is there
any way to disable it.

I tried to get around this by making the ID a primary key
with no duplicates. Now I get an error message that says
that you cannot save this item if you accidentally scroll
to a second record and place something inside. It says
that you cannot delete it and the only way to get out of
it is to completely close the form.

If not to say no duplicates or not being about to disable
the mouse scroll on this particular form, how can I make
this work?

TIA... debbie =}
 
In the form that you're using as the subform, you can set the Cycle property
to Current Record. It is a property of the form itself; see the Other tab in
the Properties window.
 
Hi Debbie,

The problem with the mouse wheel is well known and
documented in the Knowledge base (I also have this
problem). I believe the article states that you need to
create your own DLL and I found code for this on the 'net
but I couldn't make it work. I still haven't been able to
get it fixed so I've warned the data entry users to be
very careful not to use the mouse wheel. That's not much
solace but fortunately I don't have many people entering
data.

CB
 
Ken:

I'm sorry to say that it didn't work. I changed the
subform properties, but I am still able to scroll to
another record in the subform and enter data. I still get
the same window stating "duplicate values" and must close
out of the form completely and lose any information that
was changed in that record.

Thanks anyway... debbie =}
 
Back
Top