Recent content by BadOkie

Hey mhtmarsha, Try putting your code in the Forms On Active property also and see if that doesn't cure your problem. HTH Shane

Hey Ian, If you trying to set focus in a subform, you will need to do something like: Form![MainFormName]![SubformName].Form![SubformFieldName] You can put this in the last fields On Exit or you can put it in the Key Down property and trap that it's the Tab key that has been pressed. HTH Shane

Hey Avaughan, Sounds like you have it working the way you want with a macro. If that's true then you can go to design view of the form that contains your subforms and macro then click on Tools/Macros/Covert Forms Macros to Visual Basic. Access would then convert your macro that's working into...

Oh yea, one more thing. This should allow the user to hold the Alt key down and then push the number they want and it should fire the code behind the command button.

Hey Wizcow, If you already have command buttons with 0-9 as their captions then I would think you could go into each command buttons properties and under the first tab is the caption property. Try adding an "&" in front of each buttons number. ie change 1 to &1; 2 to &2. See if that does...

Hello Haytham, I think this may be what your looking for. I use this on one of my forms that has command buttons for next and previous. You can put this code in the forms On Current event and I think it will do what you want. You will need to change the names of the command buttons to the...