View Single Post
  #7  
Old June 19th, 2005, 05:40 AM
2nd_Stage_User
external usenet poster
 
Posts: n/a
Default

Again, thank you for the time and attention you have given to helping me!

Unfortunately, my background in Access is not sufficient to grasp more than
a vague understanding of what you have written here.

In the course of attempting to build this database (and, of seeking help
from individuals in this Usenet forum), I've come to see that I'll have to
equip myself with more knowledge. To this end, I just purchased "Access 2002
Bible," and I just ordered "Access 2002 VBA Handbook."

I think it's time to leave off this Usenet forum, until I have done some
more study.
--
2nd_Stage_User


"Allen Browne" wrote:

Your other question related to how to tab out of one subform into the next.

An old trick is to add a small unbound text box to the form, last in the tab
order.
In its GotFocus event, save the record, and set focus to whatever you want.

This kind of thing:

Private Sub txtJump_GotFocus
If Me.Dirty Then
Me.Dirty = False
End If
Me.Parent.Setfocus
Me.Parent![Sub2].SetFocus
End Sub

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

"2nd_Stage_User" wrote in message
...

I'd like to advance from field to field, thru entire Form (Main Form,
Subform1, Subform2, and Subform3) using just the Tab key.