Recent content by sroughley

OK, I've searched the web quite thouroughly now, and have found in several places that I need to use the setfocus method on the key down event like so: Private Sub Email_KeyDown(KeyCode As Integer, Shift As Integer) Dim mblnTabPressed As Boolean mblnTabPressed = (KeyCode = vbKeyTab)...

Cheers for the help, but I can't seem to get it to work. All that is happening is the Tabing is cycling through the fields on the parent form and not moving on to the child form. I have set the tab order to go from the parent to the child form, but it just doesn't seem to be doing anything. Any...

So you mean the last field on the parent should be, for example, 15 and the first on the sub form would then be 16? Regards. Steve.

Hey all, I am trying to find a way to tab from a field on a Parent form to a field on its child form. I am trying to do something like: Private Sub FormField1_KeyDown(KeyCode As Integer, Shift As Integer) If KeyCode = vbKeyTab Then Me.frmSubForm.Form!FormField2.SetFocus End If...

Hello all. I am new to this forum (and am thankful that I have come accross it. Pheeeww!) and find that this problem could cover many aspects of Access, so I felt that this would be the best forum to ask. Also, I should point out that I don't usually use Access for DB design (I usually use...