Recent content by davegillian

Glad to hear it! I'm doing something right at least!!!

I could use a tab control but I don't particularly like them and I think they're messy. As for the code. The code I'm using to set focus is sound as it works on all my forms but to be honest most of the time I don't use code to move between the control just the tab button. The problem...

Haha I was sure I'd tried that already but it worked this time. Thanks very much! More sleep is needed for a clear mind me thinks!

I've got a data entry form with the following piece of code which allows an existing record to be selected: Private Sub Client_Select_AfterUpdate() Me.DataEntry = False Me.Contact_Details_Subform.Form.DataEntry = True Dim rs As Object Set rs = Me.Recordset.Clone...

Ok I've tried setting focus to a textbox at the bottom and it doesn't work...runtime error 2110. Here's a simplified version of my form...with "---" representing the start of a form/subform and "***" representing the end of a form/subform. -------- MainForm Control1 Control2 Control3...

PHV: I would expect that the program Microsoft Access as a whole would display the point of focus wherever it was on a form or subform. As the subform is part of the overall form it could be argued that it still does have focus - and either way what's the point of having a subform if it isn't...

ACtually I just tried this a bit futher. It seems to work fine on a normal form but on the subform for some reason it gets confused and there's a lot of flickering on screen, an hourglass and a message in the bottom left saying "Calculating" and for the form stops responding. However... I have...

Cheers for the suggestion but yeah I've tried this. The problem isn't getting the controls in the subform to take focus. The cursor moves through the fields just as I wanted it to. The problem is that once the form has scrolled down so that all controls on the main form are out of sight the...

Hi, I've got a form that is quite long (2-3 screens). The controls on the form continue down on progressively nested subforms giving the illusion to the user that they're just inputting on one single form. The problem I have is that as you tab through all the fields once you get beyond the...

I had exactly the same problem and there's a very simple solution. For the combo box with the drop down you need the new item adding to add an event for On Got Focus as follows: Private Sub Combo_GotFocus() Me.Recalc End Sub