469,592 Members | 1,769 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,592 developers. It's quick & easy.

Trapping a next record event in subform

Hi there,

Does anyone know the simplest way I can trap the next record event in Access
2000 on a subform?

I have a main form with tab control which holds several subforms, and the
subforms are not editable unless the user clicks the "edit" button within
the subform. But I want to lock the subform's textboxes again once the user
proceeds to the next record. For some reason I was thinking form_current
would work, but it doesn't.

I am hoping I don't have to go through referencing the main form, that has
been such an ugly thing to debug in the past. remove the xs to reply
directly or post here. Thanks in advance for any advice ...

Carrie Hamm
Nov 12 '05 #1
1 5274
> I have a main form with tab control which holds several subforms, and the
subforms are not editable unless the user clicks the "edit" button within
the subform. But I want to lock the subform's textboxes again once the user
proceeds to the next record. For some reason I was thinking form_current
would work, but it doesn't.


Are you using the pertinent *subform's* "On Current" event procedure? I see no
reason why that won't work.

--
Bruce M. Thompson
bt******@mvps.org (See the Access FAQ at http://www.mvps.org/access)
NO Email Please. Keep all communications

within the newsgroups so that all might benefit.<<
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by William Wisnieski | last post: by
3 posts views Thread by Lynx101 | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.